There's one more doubt..
I have a table X, X is populated in another schema, I have the same table structure, named Y.
I want a dynamic query which takes each values of each column and builds an insert.
insert into y values (1,2,3)
insert into y values (4,5,6)
There are many datatypes on this table, smalldatetime,smallint, varchar...
Thanks!!