Bug: Cursors over queries formed with CTEs

SvdSinner

While SQL Refactor works for cursors, and for statements with CTEs, it throws an error if you try to layout the SQL on a Cursor defined by a query formed with a CTE.

I gives the standard "SQL Refactor was unable to lay out this script because some errors were found while it was being parsed. These errors have been highlighted." and it highlights the WITH CTENAme (Column1, Column2) AS portion of the script.

Brian Donahue

Hello,

Thanks for your forum post. Unfortunately, at this time CTEs are not supported by SQL Refactor. This will be completed in a future version.

Brian Donahue

Sorry -- apparently CTEs are supported, just not in conjunction with cursors.

alexey_vg

And what about support of CTE in inline table-valued function?
i have one witch can not be layout by SQL Refactor, and WITH keyword highlighted.