Forum Discussion
How implementing an hierarchy without using a recursive CTE
Hi, I've noticed that the warehouse T-SQL doesn't support the recursive ctes and this is a pity! Now, how could I implement an hierarchy in T-SQL without a such useful and comfortable feature, plea...
Hi, I need to have an hierarchy at warehouse level and not at semantic model level.
However, the recursive CTEs are also useful for other purposes.
Update: I've created this idea Adding support for recursive CTEs in a warehouse ; please vote it, thanks.
Hi pmscorca ,
Thanks for reaching out to the Microsoft fabric community forum.
You’ve taken the right step by raising and sharing the idea to add recursive CTE support. That’s currently the best path forward, as this is a platform capability gap rather than a configuration issue. Encouraging others to vote on it will help increase visibility and priority.
Best Regards,
Community Support Team