SP returning a table -- ?

[Jim Geissman]

There's an SP that in effect returns a table -- it loops and executes
statements like SELECT @field1, @Field2, @Field2

Can I capture its results in a table? I know that if it were a FUNCTION
that returned a table, that would be simple:

INSERT ResultsTable SELECT * FROM dbo.Function (@Param1, @Param2)

But how to do that if the code is a procedure rather than a function?

[John Bell]

Re: SP returning a table -- ?

Hi

Check out the form of insert statement that calls exec

INSERT INTO <TABLE> execute_stateme nt

i.e INSERT INTO <TABLE> EXEC stored_procedur e

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_5cl0.asp?frame=true

John


"Jim Geissman" <jim_geissman@c ountrywide.com> wrote in message
news:b84bf9dc.0 308291355.6af69 0b6@posting.goo gle.com...[color=blue]
> There's an SP that in effect returns a table -- it loops and executes
> statements like SELECT @field1, @Field2, @Field2
>
> Can I capture its results in a table? I know that if it were a FUNCTION
> that returned a table, that would be simple:
>
> INSERT ResultsTable SELECT * FROM dbo.Function (@Param1, @Param2)
>
> But how to do that if the code is a procedure rather than a function?[/color]