On 21 Dec 2004 05:49:33 -0800, NonNB wrote:

> Hi
>
> Is there a way in MS SQL 2000 to insert the results of a Sproc into a
> #temp table without having to create it up front ?
>
> e.g. instead of
> Create table #tmp(ID INT)
>
> insert into #tmp
> exec dbo.myProc
>
> (where dbo.myProc returns several rows of a single INT field)
>
> do something like
>
> select "exec dbo.myProc"
> into #tmp
>
> i.e. so don't have to go through the motions of manually creating the
> Temp table??
>
> Thanks in Advance
>
> Stuart