Create table from dynamic SP

Hi Everybody
I have a dynamic Sp that return data ( crossta)
I need create a table from SP result.
How can I do that.
Thanks
Pablo Salazar.
Pablo,
possible ways:
1. use (global) temp table
2. use an inline table type variable
3. use insert into your temptable
execute (your proc)
Quentin
"Pablo Salazar" <pabloesch@.yahoo.com> wrote in message
news:e$sH3o4NEHA.3668@.TK2MSFTNGP11.phx.gbl...
> Hi Everybody
> I have a dynamic Sp that return data ( crossta)
> I need create a table from SP result.
>
> How can I do that.
>
> Thanks
> Pablo Salazar.
>
>
|||http://www.sommarskog.se/share_data.html
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Pablo Salazar" <pabloesch@.yahoo.com> wrote in message
news:e$sH3o4NEHA.3668@.TK2MSFTNGP11.phx.gbl...
> Hi Everybody
> I have a dynamic Sp that return data ( crossta)
> I need create a table from SP result.
>
> How can I do that.
>
> Thanks
> Pablo Salazar.
>
>

Create table from dynamic SP

Hi Everybody
I have a dynamic Sp that return data ( crossta)
I need create a table from SP result.
How can I do that.
Thanks
Pablo Salazar.Pablo,
possible ways:
1. use (global) temp table
2. use an inline table type variable
3. use insert into your temptable
execute (your proc)
Quentin
"Pablo Salazar" <pabloesch@.yahoo.com> wrote in message
news:e$sH3o4NEHA.3668@.TK2MSFTNGP11.phx.gbl...
> Hi Everybody
> I have a dynamic Sp that return data ( crossta)
> I need create a table from SP result.
>
> How can I do that.
>
> Thanks
> Pablo Salazar.
>
>|||http://www.sommarskog.se/share_data.html
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Pablo Salazar" <pabloesch@.yahoo.com> wrote in message
news:e$sH3o4NEHA.3668@.TK2MSFTNGP11.phx.gbl...
> Hi Everybody
> I have a dynamic Sp that return data ( crossta)
> I need create a table from SP result.
>
> How can I do that.
>
> Thanks
> Pablo Salazar.
>
>