View Single Post

   
  #2 (permalink)  
Old 05-11-2008, 08:41 PM
Tom van Stiphout
 
Posts: n/a
Default Re: Doing a SELECT INTO using a Stored Proc as the data source

On Sat, 10 May 2008 20:29:14 -0700 (PDT), Deane
<deane.barker@gmail.com> wrote:

Why would you want to store the resultset in a table if you can simply
re-run the sproc?
-Tom.


>I have a stored proc that returns a resultset.
>
>I would like to deposit that resultset into a table. Kind of like a
>"SELECT INTO", but using a stored proc.
>
>If I could do this --
>
>SELECT INTO MyTable FROM MyStoredProc
>
>-- I'd be happy.
>
>What are the alternatives?

Reply With Quote