SQL Kiwi (9/17/2011)
Happy to report that I am first to get this right.I don't enjoy this sort of question though - I am a human, not a T-SQL parser.
The question could have made the same point, with the same learning value, much more simply.
It was due to that human nature (it is very easy for people to make a mistake in column aliasing as shown here) I wanted to demonstrate the question like this. As you said though, I could have given a much simpler example. This just happened to be one that I was working on as an answer to a forum question at the time of submission.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events