Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Execute Insert

What is the correct way to get values from a stored procedure and insert them
into a temp in a different stored procedure?
Using Sybase ASE 12.
Thank you in advance,
April
[197 byte] By [April] at [2007-11-9 21:10:27]
# 1 Re: Execute Insert
"April" <a_kim@netzero.net> wrote:
>
>What is the correct way to get values from a stored procedure and insert
them
>into a temp in a different stored procedure?
>
>Using Sybase ASE 12.
>
>Thank you in advance,
>April

This is how I do it in SQL Server (maybe it's the same in Sybase..)

insert into #my_temp_table
exec my_stored_proc ...(parameters)
Dave at 2007-11-11 23:52:38 >