View Single Post
Join Date: Sep 2007
Posts: 1
Reputation: seharmks is an unknown quantity at this point 
Solved Threads: 0
seharmks seharmks is offline Offline
Newbie Poster

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

 
0
  #1
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.
Reply With Quote