To CTE or not to CTE...
Having been stuck with SQL2000 for far too long, I've not really had a lot of exposure to Common Table Expressions. The answers I've given here (#4025380) and here (#4018793) have gone against the flow in that they didn't use a CTE. I appreciate that for recursion they are the beez kneez, and there are a few queries that can be greatl...