This took a while to get to work, even with googles help
To copy records from one table to another the general syntax is:
INSERT INTO tableA SELECT FROM tableB
Now thats ok provided the field names and types are identical and theres no identity fields involved.
If you have different field names then they need to be specified like this:
INSERT INTO tableA (surname,firstname) SELECT (s_name,f_name) FROM tableB
If there are identity fields involved then you can either SET IDENTITY OFF (scary) or specify all the fields excluding the identity fields:
INSERT INTO tableA (field1,field2,field3...) SELECT (field1,field2,field3...) FROM tableB
Back