O! Sh.........!!!!!!!!!!!
!!!!!!
I hate correlated subqueries. They are so slow. HAHA! Yes, I agree, correlated subqueries are the worst.
No worries, I see that mistake made quite often.
I have a community presentation, T-SQL for app developers, that's actually a topic I cover frequently.