SQL Server 2008 MERGE Statement
September 29, 2008[From SQL Server Performance]
SQL Server 2008 introduces the MERGE statement which will allow users to perform insert, update and delete operations in a single statement. In the earlier versions of SQL Server to achieve the same functionality the database developer or database administrator needed to write separate statements to perform the insert, update or delete of data in one table based on certain conditions in another table.
The article continues at http://www.sql-server-performance.com/articles/per/SQL_Server_2008_MERGE_Statement_p1.aspx