Merge statements provide a flexible approach to manipulate data in a "target" table based on a join to a "source" table. The enable users to perform a large # of updates and/or inserts in a target table using a single T-SQL statement.

The code to follow along with this tutorial can be found at www.analyticsinaction.com/merge/

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...