How can we help you today?

How can we help you today?

Many spaces after ELSE

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

Image: /hc/user_images/01JKD7A4CQC74V2HV5D3J32NT9.png

tco December 26, 2018 07:25

0

Comments

4 comments

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.

Tianjiao_Li December 27, 2018 11:57

0
Version 9.4.6.7396

I have to rename file.

tco December 28, 2018 07:51

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

Tianjiao_Li January 02, 2019 12:45

0
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

Tianjiao_Li January 03, 2019 14:35

0

Add comment

Please sign in to leave a comment.