Not a whole lot to it, unfortunately, and the CTEs were really more a symptom of the problem. For the most part, they just weren't all that good at translating ETL needs/business processes into TSQL, and there was finally one very egregious stuffing of a CTE in where it didn't really belong, and...