Veteran,

this is probably not the best way to use a CTE, a CTE is means to be re-usable across the T-SQL query and it is not meant to switch tables...