http://sqlserver-indo.org/blogs/kasimwirama/archive/2009/07/22/merge-statement-in-sql-server-2008.aspxMERGE Statement in SQL Server 2008 By : Kasim Wirama, MCITP, MCDBA In TSQL area, SQL Server 2008 has some enhancements; one of them is ability to wrap several DML statement into one by MERGE statement. Syntax for MERGE statement is : MERGE <targetenCommunityServer 2007 (Build: 20416.853)