SQL Server Stored Procedure Snap
Hello,
SQL Server Stored Procedure snap has 2 outputs, one for output parameters and another for result set. I am only interested in the resultset, how do I make sure the “output parameter” view is...
Forum Discussion
how do i make it execute either one of the output views.
For ex. if the stored procedure has data it sends output to both views (Resultset view has the total rows, Output view has 1 rows) . This causes the snaps in both paths to be executed. I only want the Resultset view path to be executed when there is data.
if the stored procedure has no data it sends output to only the Output view and if you do a count it comes as 1 even though its zero rows in stored procedure .
