With CTE () does not wrap

kepr00

I created the following sql statement

WITH cteView ( field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14 )
AS ( SELECT field1, field2, field3, field4, field5, field6, field7, field8, field9,field10, field11, field12, field13, field14
FROM dbTable)
SELECT * FROM cteView

Notice that both the Select ... and the WITH cteView (...) are on a single line.

When I ran the SQL Layout command it reformatted as expected with one exception

WITH cteView ( field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14 )
AS ( SELECT field1, field2, field3, field4, field5, field6, field7, field8, field9,
field10, field11, field12, field13, field14
FROM dbTable)
SELECT *
FROM cteView

The field list within the WITH cteView (...) parens did not wrap. I expected this field list to wrap in a similar way as the Select Statement.

Is there a setting that I can adjust so that the WITH cteView (...) statement will wrap like a select statement?

Dave Mellors

There doesn't appear to be a way of achieving what you are looking for.

I have logged this as a feature request so that it might be included in a future release.