Cut Paste Function in SQL Query

[jhargram]

Hi All- I want some suggestion regarding this moving data from one table to another table. Mainly we are using "Insert into table2 select* from table with where condition".



But in this case data moved one table to another as copy paste.

Is it any way to go data as cut paste...


Thanks in Advance

[pbaldy]

You have to run a delete query after the append query. It is often a mistake to move records around like that (archive tables for example).