Kenny,

Thanks for pointing out the performance implications of using a CTE versus a temp table multiple times in a query.