>
You did not specify SQl Server version. >
>Good question. Someone with 2005 might want to use CTEs (there are multiple ways to solve this)....but since some still have 2000, I'd say either one.
See my answer with derived tables, should work in either version.
If it's not broken, fix it until it is.
My Blog 
