Hello everyone

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
AS
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.

Regards
Ishu