Update Query

• savee

  Say Hey Kid

  Points: 691

  More actions

  February 11, 2010 at 9:52 pm

  #220563

  Hi

  i want to update a table from another server and also i want to insert the missing records from that table...

  both the table has same structure...

  pls help

  its urgent

• wschampheleer

  SSCertifiable

  Points: 5504

  More actions

  February 12, 2010 at 12:07 am

  #1117889

  Use a merge statement.

  To get data from the remote server you can use either SSIS or a linked server.

  Regards,

  Willem
  http://wschampheleer.wordpress.com[/url]