Merge statements provide a flexible approach to manipulate data in a “target” table based on a join to a “source” table. This enables users to perform a large number  of updates and/or inserts in a target table using a single T-SQL statement.  In subsequent tutorials we will build on this knowledge of Merge statements to build slowly changing dimensions

The code to follow along with this tutorial can be downloaded here