Why on earth would anyone want to do this? The scope of a temp table can actually give it a longer life span than a cte which is only "defined within the execution scope of a single SELECT, INSERT, UPDATE, MERGE, or DELETE statement". On the other hand temp tables are typically created in 2 steps while cte's can be created in one. There are clearly uses for both temp tables and cte's but not as data sources for one another.