CTE on new line with commas before items is adding an extra line
When using the Lists > "Place commas before items" combined with the CTE >" Place CTE name on a new line" options, the subsequent CTEs are getting placed on new lines after the comma is already on a new line, resulting in:
WITH
  myCte
AS ( SELECT 1 a )
,
  mySecondCte
( Col1, Col2 )
AS ( SELECT
       'Test' AS ThisIsAColumn
     , 'Test2' AS ThisIsAnotherColumn
     FROM Person.BusinessEntityContact )
SELECT *
FROM myCte
I believe this combination of settings should be resulting in:
WITH
  myCte
AS ( SELECT 1 a )
, mySecondCte
( Col1, Col2 )
AS ( SELECT
       'Test' AS ThisIsAColumn
     , 'Test2' AS ThisIsAnotherColumn
     FROM Person.BusinessEntityContact )
SELECT *
FROM myCte
Please fix, or add/modify options to make this possible.
 James LeGrand
    
 shared this idea
James LeGrand
    
 shared this idea
      
    