Competition: What’s your favorite Redgate tool? Enter now.

With CTE () does not wrap

kepr00kepr00 Posts: 43 Bronze 2
edited April 19, 2007 8:45AM in SQL Refactor Previous Versions
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?
Steve T

Comments

Sign In or Register to comment.