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? |