I want to create a view in SQL as tableau software do not support CTE function. May I know anyone out there knows how to create a view with CTE?
Currently, I am unable to add a view as I am using a MAXRECURSION (I am doing recursive btw). The error message is "Incorrect syntax near the keyword 'OPTION'."
I understand that the SELECT clauses in a view definition cannot include the OPTION clause and several other things.
Hence, how do I solve this issue? Help is greatly appreciated!