Zen of SQL: UPSERT and More with MERGE

On SQL Server version 2005 and prior this was accomplished using separate INSERT and UPDATE statements. ...

pratchev.blogspot.com