Creating a Temp table that is populated by a stored procedure

Creating a Temp table that is populated by a stored procedure

Post by Kevin Stephe » Fri, 22 Jun 2001 05:33:40



Can this be done?

Exec spWhatever into #Temp?

 
 
 

Creating a Temp table that is populated by a stored procedure

Post by Keith Kratochvi » Fri, 22 Jun 2001 05:51:27


nope, you must create the table first:

create table #temp
insert into #temp exec sp_Whatever

--
Keith
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:> Can this be done?

> Exec spWhatever into #Temp?