Take a look at the MERGE operator in Books Online. It will insert into the table when the record is not there and update the DESC or whatever other non-key fields when a record is found and DESC values differ. See if this helps you along or if you would like a example (in which case I would ask you to provide usable data and table definitions. )