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)
 #Temp ?

Author  Topic 

lane0618
Posting Yak Master

134 Posts

Posted - 2002-10-15 : 18:07:01
Is it possible to take the table that results from this sp and insert it into a temp table?

[dbo].[get_ftrTable_t]
@spno = 'ss-000-test-01'

Thanks,
Lane

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-10-15 : 18:42:34
INSERT INTO myTable (col1, col2, col3)
EXECUTE dbo.get_ftrTable_t @spno='ss-000-test-01'


Just make sure the columns listed in the INSERT section correspond to the results returned by the stored procedure.

Go to Top of Page
   

- Advertisement -