If you used the original script to create the sp, it has errors.

Copy the script from my post that has the corrected version.

The script is an ALTER statement. You should be able to run it from a new query that is connected to the db you created the sp in.