• Certainly this is a good option, but as several others stated there is a MERGE statement coming out in SS 2008 which may make this obsolete. An example of MERGE can be found on SSC at http://www.sqlservercentral.com/articles/Advanced+Querying/3122/

    I can say that the MERGE on Oracle performs very well so I'm looking forward to the SQL Server implementation.