MSSQL database: stored procedure learning

In this example we take the head from the two tables and then merge into a table.