Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonysunny
Starting Member
6 Posts |
 Posted - 2008-03-04 : 05:40:17
|
| Hai, How can we access a temporary table created in a stored procedure from another stored procedure.plz help.......... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-04 : 06:04:25
|
| Is the second procedure called from the one containing temporary table? |
 |
|
|
sonysunny
Starting Member
6 Posts |
Posted - 2008-03-04 : 06:30:19
|
| No, it is not called from same procedure. Suppose SP1 is a stored procedure and it contains a temporary table Temp1. SP2 is another stored procedure. How can we access Temp1 from SP2. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-03-04 : 07:28:47
|
if SP2 executes within SP1 scope, SP2 can access the temp table of SP1.If not, you will have to use global temp table
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Accessing temporary table from stored procedure