I am trying to use CTEs as part of my derived table SQL. The generated SQL puts the CTE definitions as part of a sub select which does not seem to work it seems to get ignored and I have no results. Is there a way to do this so the WITH clause is not part of an inner select ?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.