EXEC SP and suppress built-in SP to return data
Dear experts,
I have a SQL 2008 database and I call a stored procedure from C# code. The SP called inside him called other SP which return recordset. Look on the pic. the result of execution.
The question is: how to avoid returning back to C# code the first result ? I guess I change the SP and pass a value that tell to embed SP to not return data, but is there a other way?
D--Temp-Untitled.png
I have a SQL 2008 database and I call a stored procedure from C# code. The SP called inside him called other SP which return recordset. Look on the pic. the result of execution.
The question is: how to avoid returning back to C# code the first result ? I guess I change the SP and pass a value that tell to embed SP to not return data, but is there a other way?
D--Temp-Untitled.png
Ganapathi
You will have to remove the select statement that selects the result.
Can you post the sub-procedure code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found the solution on my own.