One of the new features of SQL Server 2008 is the MERGE statement. Basically MERGE will insert data to a target table from a source if the data is not there other wise it will update/delete from the target table. Using the MERGE statement will actually improves the performance a lot.
1. To further illustrate I have created a [...]
