CTEs are just so much more elegant and readable and easier to test each step - I've ended up with 6 in one query to build up data and do running totals!