Return
-
Title
Error: "This type of SQL statement is not supported." -
Description
I run the following sql statement in SQL Optimizer for SQL Server 6.5
WITH temp(column1) AS (SELECT '1')
SELECT * FROM temp
And I got the error:
This type of SQL statement is not supported. -
Resolution
The WITH Clause is new in SQL Server and actually we do not support this kind of slq statement.
An enhancement request is submitted and it will be fixed in a future release.
CR number: ST 55455 -
Defect ID
ST 55455