• I agree, a CTE is the better way to do this now. It provides greater readability and flexibility.