quickest way to copy/move all data from one table into another

[hoggle]

I need to know the quickest way possible to move or copy all data from one table into another. Should I truncate the destination table then use INSERT, a DTS package, or drop the destination table and use a SELECT INTO...or is there another way?

thanks

 

[PTina]

I've used DTS for some large tables and the performance was good.

 

[SQLRickster]

DTS is the quickest and most efficient way to copy data from one table to another. Truncate the destination table. (Deleteing will cause logging and slow the operation down.) and DTS the new data into the destination table.

Hope this helps,
SQLRickster