MS SQL

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

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

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.

•

Join Date: Dec 2006

Posts: 645

Reputation: binoj_daniel is an unknown quantity at this point

Solved Threads: 17

binoj_daniel binoj_daniel is offline

Offline

DaniWeb Expert

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

Oct 24th, 2007

What are the keys in the table?

Binoj Daniel
Best Place to hunt for Code | Quality Web Designing | Custom Software

•

Join Date: Aug 2006

Posts: 2,065

Reputation: Ramy Mahrous is just really nice

Solved Threads: 256

Ramy Mahrous Ramy Mahrous is offline

Offline

Postaholic

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

Oct 24th, 2007

Use differential Backup...
or you can use insert select
like

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
INSERT INTO table1 VALUES (SELECT DISTINCT a,b,c.. FROM table2)
insert into table1 values (select distinct a,b,c.. from table2)