which is the best way to move selected record from a table to a new table?

For example:

Select Sept records from myTable (real), copy them to a new table ("Table_Sept" for example), e delete them from the original one.

one way is ..
best way !!!! now that i dont know

SQL Commands ...

select * into newtable from oldtable

delete from oldtable 

Use an OUTPUT clause on the INSERT to the new table to capture the key column(s) to use to go back and DELETE from the old table. If you'd like further details and code on this method, just let me know what the key column(s) are for your table.

1 Like