bitbucket-25253 (12/4/2012)
My apologies to all .....1. I did test the code multiple times ...
2. When testing the ; was NOT present.
3. I can only guess, but was using a brand new lap top when submitting the question and typing the QOD rather than a cut and paste from SSMS, and somehow or other I pressed the semi-colon key.
4. Poor excuse on my part for the error so let me say again:
My apologies to all
We're all human Ron. Apology not needed but certainly accepted. 😉