Stored Proc problem

M

manoj241176

Hi,
I am having stored proc which returns 2 resultsets, now i want to
call this stored proc within another stored proc, but i want to use
only the second resultset from the previous stored proc. So please tell
me how can i do this.??

Thanks in advance,

Regards,
Manoj Singh.
 
D

Dave Sexton

Hi Manoj,

Split the first procedure (the one that produces two results sets), into two different procedures. Call only the procedure that
produces the second result set.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select multiple table in 1 stored proc 3
Tough Transaction Problem with Stored Procs and ADO. 2
Multi select stored proc and strongly typed data sets 1
Looking for Comments on Code 5
DataSet.WriteXML Vs. SQL Server 2000 XML performance issue??? 5
DataSet has no rows when proc is returning rows?? 3
DaatSet has no rows when proc is returning rows?? 1
Stored Proc with EXEC Causes Error 2

Top