CTE in Query Builder

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
KCarterSr
Posts: 5
Joined: Thu 11 Dec 2014 20:35

CTE in Query Builder

Post by KCarterSr » Thu 11 Dec 2014 20:42

When I try to use a simple query in the query builder that has a CTE I get the following error.

Example:

WITH statement......
SELECT statement.....

Error: One of the following statements expected: SELECT, INSERT, UPDATE, DELETE.

The code is correct. Is this a bug?

Thanks
K. Carter Sr.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: CTE in Query Builder

Post by .jp » Fri 12 Dec 2014 08:45

Unfortunately, Query Builder does not support CTE yet. You would suggest the feature at our User-Voice forum.

Post Reply