I was trying exactly this query

The comment was a notation of myself to not wonder why later. I can (and should) move it outside the query.

However, when I ran it, I was getting "Incorrect syntax near ':'."

Simply removing the SQL comment caused the code to execute correctly. I'll move the comment anyway.

The part that I find most interesting is that I have other queries that seem to do this fine. I'll truncate this because it's huge. Although my other queries are one rather than two.

For what it's worth, according to CF Builder and Notepad++, the erring queries do end with carriage return and new line on each line (\r\n).