Inserting Duplicate Data

• apat

  SSCertifiable

  Points: 5929

  More actions

  September 22, 2009 at 5:54 pm

  #96326

  Hi All,

  I have a question on inserting data to a table where some data already exists and I don't want to add them again. here is the scenario,

  I have two tables.. Source and Destination( where I want to insert data). Both tables have same 5 columns. There is no Unique Constraint, Primary Key, Composite PK etc and I can't add anything. Source Table has 200 records and Destination table has 90 records. I want to insert those 110 records from source table to Destination table which do not exists in destination table now.

  Also, in both the tables there are duplicate records in all the columns. Each column has duplicate records. but at any time one particular ROW(Records) is not Duplicate with any other ROW(Record).

  How to insert this data? Thanks in advance...

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  September 22, 2009 at 6:24 pm

  #1057220

  Check the other thread.. I already answered it over there..

  http://www.sqlservercentral.com/Forums/Topic792280-392-1.aspx

  CEWII