SQLServer存储过程同时返回分页结果集和总数

CREATE proc [dbo].[usp_manyidu]
(
 @seatno nvarchar(30),
 @pageIndex int,
 @pageSize int,
 @rsCount int out
)
as
begin
 declare @sql nvarchar(max) --拼接内核SQL
 declare @where nvarchar(max)=' where 1=1' --查询条件拼接字符串
 declare @cols nvarchar(max) --查询字段、计算字段
 declare @sort nvarchar(50) --排序
 
 set @sql=' from dbo.log where seatno is not null and seatno<>'''' group by seatno '
 set @cols='seatno,SUM(case when manyidu=0 then 1 else 0 end) as manyi,
 SUM(case when manyidu=1 then 1 else 0 end) as yiban,
 SUM(case when manyidu=2 then 1 else 0 end) as bumanyi,
 SUM(case when manyidu IS null or manyidu='''' then 1 else 0 end) as weipingjia'
 
 set @sort='order by seatno'
 
 if(@seatno <>'')
 set @where+=' and seatno='+@seatno
 
 
 declare @strSQL nvarchar(max)
 
 set @strSQL=N'select * from (select ROW_NUMBER() over('+@sort+') as tmpid,* from( select * from (select '+@cols+@sql+') as tmpTable1'+@where+') as tmpTable2) as tmpTable3'
 +' where tmpid between '+STR((@pageIndex-1)*@pageSize+1)+' and '+STR(@pageIndex*@pageSize)
 print @strSQL
 exec(@strSQL) 
 
 set @strSQL='select @total=count(*) from (select '+@cols+@sql+') as tmpTable'+@where
 
 print @strSQL
 exec sp_executesql @strSQL,N'@total int out',@total=@rsCount out
 
 
end
GO