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?