var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
create output of strored procedure into a table
please have a look at the code below
create table tab1
int1 int null,
int2 int null
insert into tab1 values (11,22)
insert into tab1 values (33,44)
insert into tab1 values (55,66)
CREATE PROC test_proc
SELECT int1, int2 from tab1
create table tab2
int11 int null,
int22 int null
I would like to run test_proc and store the values to tab2. please help witht the query.
Something like insert into tab2 exec test_proc -- which obviously does not work.
I'm using sybase 15
Thanks in advance.
Create a proxy table on the proc, then insert into the new table by selecting from the proxy table.
I am not sure but i guess there is a limitation in SP that DDL commands can't be executed from within a SP.