存储过程为什么无法返回结果集的记录数？

我的存储过程是这样的
CREATE procedure pro_xxtj(
@qsrq nvarchar(20),
@jsrq nvarchar(20)
)
as
DECLARE @s nvarchar(2000)
DECLARE @s1 nvarchar(2000)
SET @s = ''
SELECT @s = @s + ',' + quotename([bumen_name]) 
+ '=sum(case when [bumen_name]=' + quotename([bumen_name], '''') 
+ ' then 1 else 0 end) ' FROM jftj1 GROUP BY [bumen_name], [bumen_px] ORDER BY [bumen_px] ASC 

set @s1='select [lm_name] as 栏目' + @s + ',[总数量]=count(*) from jftj1 where xx_shentimes2>'+@qsrq+' and xx_shentimes2<'+@jsrq+' group by [lm_name],[lm_px] order by [lm_px] asc'

EXEC (@s1)
GO
用asp调用后可以获得结果集，但是无法获得记录数rs.recordcount是因为什么呢？

sql ="exec pro_xxtj '"&qsrq&"','"&jsrq&"'"
rs.open sql,conntmp,1,3
rs.open sql,conntmp,2,3
rs.open sql,conntmp,3,3
都试了，还是不行