Devart Forums

Posted: **Fri 28 Jul 2017 02:50**

How do I achieve the following formatting?

SELECT pp.ProductID
    ,pp.MakeFlag
    ,pp.FinishedGoodsFlag
    ,COLUMNS_UPDATED()
    ,NULLIF(pp.MakeFlag, pp.FinishedGoodsFlag) AS 'Null if Equal'
FROM Production.Product pp;

I've tried setting:

Stacked List -> No space between comma and list item in stack ON
Stacked List -> Place comma before item in stacked list ON
SELECT -> Select List -> Line break before first column OFF
SELECT -> Select List -> Stack columns -> simple list

But the above settings add spaces to align the columns:

Code: Select all

SELECT pp.ProductID
      ,pp.MakeFlag
      ,pp.FinishedGoodsFlag
      ,COLUMNS_UPDATED()
      ,NULLIF(pp.MakeFlag, pp.FinishedGoodsFlag) AS 'Null if Equal'
FROM Production.Product pp;

Posted: **Fri 28 Jul 2017 10:45**

Please perform the following:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile.
4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
5. Expand the 'SELECT -> Select List' node.
6. Unselect the 'Stack columns' option.
7. Click 'OK'.

Devart Forums

Select list formatting

Select list formatting

Re: Select list formatting