|
Home > Archive > ASE Database forum > October 2005 > Dump the output of the sproc into a temp table.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Dump the output of the sproc into a temp table.
|
|
| Frank Rizzo 2005-10-27, 8:21 am |
| How can I dump the data returned by the stored proc into a temp table?
I tried the following, but it says invalid syntax.
CREATE TABLE #temp (
col1 int,
col2 int,
col3 varchar(30)
)
INSERT INTO #temp
EXEC MyDatabase.dbo.sp_Customers 5
| |
| Sherlock, Kevin 2005-10-27, 8:21 am |
| create a proxy table which maps to the stored procedure. Then, use "select *
into #temp from <proxy_table>".
"Frank Rizzo" <none@none.net> wrote in message news:4359cb07$1@foru
ms-1-dub...
> How can I dump the data returned by the stored proc into a temp table?
>
> I tried the following, but it says invalid syntax.
>
>
> CREATE TABLE #temp (
> col1 int,
> col2 int,
> col3 varchar(30)
> )
>
> INSERT INTO #temp
> EXEC MyDatabase.dbo.sp_Customers 5
|
|
|
|
|