Posted by Erland Sommarskog on 11/29/05 12:09

Ks (kpunjani@gmail.com) writes:
> I have a little scenario here, i am need of inserting some rows into a
> temp table which will be returned by a procedure... Here is little
> explanation
>
> I am planning to make a proc A and a temp table in proc A.
> I will be calling proc B from Proc A.
> What i want is the data returned by Proc B should be inserted into Proc
> A's Temp table.

Just do it. The temp table created in A, will be visible from B.

I cover this in an article on my web site:
http://www.sommarskog.se/share_data.html

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]