** Update**

I went through the example as presented and even though it worked it generated error messages (SQL 2012).

I changed the script to what I thought it should be...