View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 05:23 AM
Nick Meyer
 
Posts: n/a
Default only update if values different

What is the best way to UPDATE a row only if values are different? We
have a mainframe extract that literally has 100,000 rows and am worried
about the performance of just running INSERTs each night.

Is there a simple comparison command or would you have to nest a SELECT
statement? Thank you,

Nick

Reply With Quote