Compare column in two tables

• sanspirit

  SSC Veteran

  Points: 224

  More actions

  January 9, 2008 at 5:19 am

  #63142

  Hi

  I would like to compare rows which are in two different tables which have the same column and data type where the data in one table1 column (A) has repeated data. When new data is added to table1 column (A) the unique rows should be selected and added to another table2 column (A) on the same database.

  Both tables have the same column name but the rows in table1 column (A) are repeated while the rows in table2 column (A) are unique.

  Data is always added to table1 columnA everyday. How do i selected only the unique rows in table1 column (A) and add it to table 2 (A). To give an idea there are about 50,000 rows in table1 column (A) and about 1000 rows in table 2 column(A)

  Any help is much appreciated. New to SQL so please give in detail.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  January 9, 2008 at 6:37 am

  #766128

  Please don't cross post.

  Answered here: http://www.sqlservercentral.com/Forums/Topic440533-338-1.aspx