Hello All,


I am new to stored procedure programming.I have the below mentioned scenario.


I have got two stored procedures p1 and p2. from p1 I am calling p2.
p2 returns two result set's. I need to store one of the result set returned by p2 to a temporary table in p1.


p2 does not have any out parameter, it just has two select's which returns two resultset's.

Please let me know if this is possible.

I think this is not possible. A better approach is that creating temp table in p2 SP and inserting values in it. From P1, those results can be retrieved from the temp tables.

These temp tables either may be temp tables or permanent tables. In the latter one, temp tables should be dropped explicitly.