Is it possible to write a direct query and use the table output as input to another direct query?

[FrankKrogh]

I have many times experienced that the CTE-design executes much slower than storing the CTE-expression into a temporary (#) table and then apply this table in the final SELECT expression. 

I believe that it is not allowed to have two or more SELECT-expressions in the same direct query. Is it possible as a workaround to write a direct query and then apply the table output as input to another direct query?

Are there any example on this kind of direct query design?

[amitchandak · Accepted solution]

@FrankKrogh , It is not good idea to have complex query in case of direct query. You can use view or CTE. But try have table which you can simply query that would be better