I've got a query wich is execute with EXEC.
I need to do this:
@QUERY = select col1 as C1,col2 as C2,col3 as C3 from TABLE
insert into TABLE2 values(C1,C2,C3)
I need in fact to insert in TABLE2 the result of the query.
Thanks for your help .