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
dvplayltdAsked:
Who is Participating?
 
dvplayltdConnect With a Mentor Author Commented:
It look like the addingg additional param is the solution.
0
 
GanapathiFacets DeveloperCommented:
You will have to remove the select statement that selects the result.
0
 
GanapathiFacets DeveloperCommented:
Can you post the sub-procedure code?
0
 
dvplayltdAuthor Commented:
I found the solution on my own.
0
All Courses

From novice to tech pro — start learning today.