Creating a stored procedure to return the rowcount of another stored procedure

Question

Title says it all - is it possible to do this? I have some filters set in my source Stored Procedure and I really don't want to have to duplicate it in another just to get the rowcount.

Answer 1

can you give an example?? You could call the sproc and just do a count on the results?

Answer 2

The only way I know how to do this is to insert into a temp table from the stored procedure and then select the count. Unfortunately, there's no pretty way to perform a "select" on a stored procedure.

CREATE TABLE #stuff (id int, status char(6))
INSERT #stuff (id, status)
EXEC dbo.sp_get_stuff

SELECT count(*) FROM #stuff

DROP TABLE #stuff

Edit

The above method will allow you to select from a stored procedure, but as Greg pointed out, a rowcount can be simplified to:

EXEC dbo.sp_get_stuff
SELECT @@Rowcount

Answer 3

This also works:

create proc pTest1
as
select * from comp
go

create proc pTest2
as
exec pTest1
select @@rowcount
GO

Answer 4

If you are really trying to fine tune as much as possible, then you will have to change the source stored procedure. If you are looking at performance, then returning the rowset just to get the count is not something to even consider.