Copying Records From One Table to Another Using SQL Queries
Copying records from one table to another within a single database is pretty trivial.
Its just a matter of running a query with the structure shown below
insert into TableA(FieldA, FieldB, FieldC)select FieldA,FieldB, FieldC from TableB
If TableA and TableB reside in different Databases you would have to use a fully qualified Table names.
Came across this one today and I just had to share it. 
Tags SQL, SQL Server
