DaniWeb IT Discussion Community - View Single Post - How to copy distinct records from one table to another using SQL 2005

•

Join Date: Sep 2007

Posts: 1

Reputation: seharmks is an unknown quantity at this point

Solved Threads: 0

seharmks

Offline

Newbie Poster

How to copy distinct records from one table to another using SQL 2005

Oct 24th, 2007

I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same name, same schema etc.