Sql stored procedure to compare two table and update data in one table if we r having non matching records

• getalok_akg

  Ten Centuries

  Points: 1006

  More actions

  December 7, 2011 at 9:00 pm

  #261081

  Hi All,

  I need nelp to write stored procedure , pls guide me on this :

  Requirement :

  Having two table A & B , both table are same , but for table A , identity column having positive value while table B identity column have negative value .So our requirement is that table A get periodically update , So we want to match both table and if get updated value in table A , we want to update table B for that row and after that again we need to update one more fact table for that negative identity value of table B .

  many many thanks ....Pls reply asap ..

  Thanks,

  alok

• okbangas

  SSChampion

  Points: 11773

  More actions

  December 12, 2011 at 3:58 pm

  #1420309

  Have a look at the merge statement.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]