Hello
I've got a stored procedure that returns a data set. The procedure is made up of dynamic sql including a number of dynamic CTE's
What I need to do is count the rows returned in the procedure without returning the rows. Reason being that if the are now row another procedure is called. Is there a straight forward way to do this?
Any suggestion welcome
Ron