Amar Pogaku (1/9/2009)
Hello,Thank you for bringing this to my attention.
The original code I submitted parses fine. But you are right there is something going on when you copy it off from the website; I noticed the same problem. Even when I parsed the code without the failing lines (6 & 13) it fails with the same "Incorrect syntax" error. I will look into the cause and make the appropriate changes.
Also, note that in the drop statement the object is not correct although this doesn't affect creation of the SP itself. I will fix this too once I figure out how to edit submitted/approved code. For the time being you may use the code file I attached to this post. I hope it works smoohtly 🙂
Amar
I've seen several other scripts that won't parse cleanly after they've been posted/cut/pasted from the website. I doubt that your original code had an error.
Thanks for the attached document. That script worked well for me. 🙂