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

New "Edit Formatting Styles" beta feature for SQL Prompt

NgainerNgainer Posts: 15 Bronze 2
edited August 24, 2016 8:56AM in SQL Prompt
SQL Prompt version 7.3.0.422

Is there a way to keep CTE queries from being nested within the "WITH" clause with the beta version of SQL Prompt Format SQL command? When I have a "WITH" clause with multiple CTE queries, after applying "Format SQL" the new formatting style nests the queries with a lot of white space left over.

Example:
WITH query1 
AS (SELECT col1
        FROM table1

    ),
query2 
                        AS (select col1
                               from table2)
select 1
  from query1 AS q1
   join query2 AS q2
      on q1.col1 = q2.col2;

Comments

Sign In or Register to comment.