Will that append the records to the target table?


>>This client wants to archive records from one table into another before deleting the source records.
>What is the best syntax for doing that with TSQL?
>
>Thanks



select Fields into MyArchiveTable from myTableToClean where some condition

-- Now if we can truncate the original (no dependencies) -- it would be the fastest metod

truncate table myTableToClean