>>Hi everybody,
>>
>>Here is a question http://forums.asp.net/p/1390729/2979048.aspx#2979048
>>
>>Using one SP is it possible to return number of records in CTE in the output parameter as well as the actual select result?
>>
>>Thanks in advance.
>
>How about:
>

>SELECT * FROM CTE
>SET @TotalCount = @@ROWCOUNT
>

But we need to farther filter the result of cte. We just need to return the original number.