dbForge Query Builder for SQL Server - CTE

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
rromila
Posts: 1
Joined: Tue 31 Jan 2012 07:51

dbForge Query Builder for SQL Server - CTE

Post by rromila » Tue 31 Jan 2012 08:02

Hi, when I try to use CTE statements in this product I get:
"Unexpected symbol" 'WITH'

My query is as follows:

WITH CRSDEF_LOADCATRANS
AS
(
SELECT *
FROM [SRC].TRANS.LoadCatTrans WITH(NOLOCK)
WHERE qls_load_cat_src = 'STMCRSDEF'
)
select * from CRSDEF_LOADCATRANS
Is this a bug?

alexa

Post by alexa » Tue 31 Jan 2012 10:54

Currently, the WITH clause is not supported. We will support it in one of the next versions of the product.

Post Reply