troubleshooting Question

INSERT into table

Avatar of renjitkumar
renjitkumarFlag for India asked on
Microsoft SQL Server
7 Comments1 Solution1645 ViewsLast Modified:
Hello All,

I need your help regarding below described issue.

I have two stored procedures, lets say SP1 and SP2. Here the SP1 is an old stored procedure which we already developed long before and lot of functionalities are depending upon it. This SP1 will give a single resultset with 5 fields in it. We don't want to disturb SP1 at any case.

Now SP2 is a new one which i am developing now.  As per the functionality I may need to call the SP1 multiple times from inside the SP2. For example inside a while loop in SP2.

Now the sitaution is; SP1 will give a resultset for each call. I need this result set stored in a temporary table and i need to show all these resultset together instead of different result sets..

Is that possible?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros