Re: Doing a SELECT INTO using a Stored Proc as the data source
by Tom van Stiphout <no.spam.tom7744@[EMAIL PROTECTED]
>
May 10, 2008 at 09:02 PM
On Sat, 10 May 2008 20:29:14 -0700 (PDT), Deane
<deane.barker@[EMAIL PROTECTED]
> 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?
