When I cut and pasted the first procedure into a new query window and attempted to execute, I got a whole series of syntax errors:

Msg 102, Level 15, State 1,...