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.