cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdmlc Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

You can work around it with a sub-query (just move the CTE in to your main query as a sub-query), which is crude and very SQL2K'ish but that is the world we live in, apparently.

adrez86 Regular Visitor
Regular Visitor

Re: Custom query with CTE not supported (bug?)

@v-qiuyu-msft  Was there ever a response/feedback internally on this?

Highlighted
bjcw0 Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

I don't think offically. I was able to work around it with making the query into a view and then selecting from there.

EVEAdmin Member
Member

Re: Custom query with CTE not supported (bug?)

So, it seems CTEs are only supported in Import mode and not in Direct Query. Still the case?

bjcw0 Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

To be fair I have not tested recently. But I have not seen an update on the matter from Microsoft. I will test again when I have some time and post and update here.