Hello.

I have a table and i want to take my values from that table and insert to another table.

SELECT * from Table1 where 1=1;


INSERT INTO Table2 VALUES(...The values from Table1)


This is like a for statement.

I have more than 1 rows and i am using a stored procedure.

Are there any for-like statements for stored procedures in Sybase?

Thanks...

You could just do

select * into Table2
from Table1

or if you need select columns

insert into Table2
select col1, col2, etc from Table1