Stored Procedure Returns

[JP]

I have a stored procedure that does a select and returns 0 or more rows as a result.

How can I determine how many rows are returned from this stored procedure within another stored procedure?

thx

[JHausmann]

Something like (although I haven't tested it) the following should work:



CREATE PROCEDURE rows_returned
AS
DECLARE @printline as CHAR(80)

EXEC your_stored_procedure
select @printline = @@rowcount + " Rows selected"
PRINT @printline



[This message has been edited by JHausmann (edited 09-07-1999).]

[JP]

Thanks, this works after putting a convert() around the @@rowcount when building the select for @printline.