Many spaces after ELSE

tco

Try to format this script

SELECT ISNULL((SELECT 1 FROM xxxxxxxxxxxxxxxxx)

             ,CASE WHEN Track_Type_Fld=''

                        THEN 2

              ELSE PackageQuantity

              END)

I get not butifull result

Tianjiao_Li

Can you confirm the full version number of your Prompt as well as attach your style file?
https://documentation.red-gate.com/sp9/formatting-your-code/using-styles

Thanks.

tco

Version 9.4.6.7396

I have to rename file.

Tianjiao_Li

Thanks! I can reproduce it and have escalated it to the dev team. I'll keep you posted.

Tianjiao_Li

The dev team has confirmed that we're planning to look into this later in the year so please keep an eye on the release note! https://documentation.red-gate.com/sp9/release-notes-and-other-versions