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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Return SP results to a temp table

Author  Topic 

cwburke
Starting Member

16 Posts

Posted - 2002-05-20 : 11:51:50
How do/Can I return the results from a stored procedure into a temp table?

ie)
Select *
Into #myTemp
From sel_Recs @ID=1

Seems like I've seen this somewhere before but can't remember where?

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-20 : 11:59:21
insert #myTemp
exec sel_recs @id = 1

<O>
Go to Top of Page
   

- Advertisement -