What are the challenges you face when working across database platforms? Take the survey

New "Edit Formatting Styles" beta feature for SQL Prompt

NgainerNgainer Posts: 16 Bronze 3
edited August 24, 2016 8:56AM in SQL Prompt
SQL Prompt version

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.

WITH query1 
        FROM table1

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


Sign In or Register to comment.