1 Reply Latest reply on Jul 6, 2016 10:39 AM by Derrick Austin

    Does Tableau 9 support SQL Common Table Expression (CTE)

    Doug Hall

      I am receiving errors when I use a CTE.

       

      • [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'WITH'.
      • [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
      • [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.

       

      The SQL query runs without any issues in Microsoft SQL Server Management Studio.

       

      Older posts in the Tableau community forum state that Tableau does not support CTE in Microsoft SQL.  Is this still true in version 9.#?