My purpose in using IF NOT EXISTS was to determine if I did not receive a result, and to determine if I did receive a result. Crazy, eh? Anyway, I only wanted to use RAISERROR because the instructor told us we had to use it. I'll pull the ORDER BY out, but that was also requested by the instructor.

>If you're using

>IF NOT EXISTS (select ...)

>then, as I said, get rid of the ORDER BY.

>Otherwise, can you show the exact piece of code which is failing?