The CTE and NoCTE versions are comparable on a small data set. I'd like to try them both on a million row data set and see how they compare.

Perhaps this evening I will have a chance to set it up.