updating data

• achowe

  SSCrazy

  Points: 2075

  More actions

  July 9, 2003 at 3:16 am

  #159354

  I have 2 tables.

  Table A has existing records

  Table B has new records to be updated into Table A.

  However, I need to avoid duplication. What would be the best way to insert the data from table B into table A, but only if the data doesnt already exist in Table A. Is there a clause/function I can use?

  Thanks

  If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  
  If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

• Antares686

  SSC Guru

  Points: 125444

  More actions

  July 9, 2003 at 3:38 am

  #464647

  Please be carefull of duplicating posts. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=13988&FORUM_ID=9&CAT_ID=1&Topic_Title=updating+data&Forum_Title=General