still a problem, it is wrapping my entire query in a CTE, but because my query already contains a CTE, sql server gives an error. Nesting CTEs is not allowed