Shame on me, I completely missed the new addition to T-SQL in SQL Server 2008, the MERGE command. It let’s you perform inserts, updates and deletes against a table in a single statement. This should come in handy if you’re building data warehouses or have a general need to keep tables in sync.