How to keep short IIF functions on one line in SELECT clauses?

14 Posts
2 Users
1 Reactions
3,516 Views
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

I will need to add "+" as a Concat Operator similar to the existing "||". I need to investigate. 

grafik

 

For now profile 6 is probably the best work-around

Regards

Guido


Reply
Posts: 13
Topic starter
(@kmpel)
Member
Joined: 7 months ago

Thank you. However, the + sign LineBreak before is a nice-to-have. The main issue is a large empty space in the column calculation/function. Please see the screenshot.

image

Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

please try this

grafik

Reply
Posts: 13
Topic starter
(@kmpel)
Member
Joined: 7 months ago

Thanks, I used. It's better. But for the purpose of this exercise, I added more parts into the concatenation 😁, and it's sort of quirky. Please see the screenshot below in SSMS22

image

The standalone Win SQLinFORM app shows a different result, and this one is more suitable for formatting:

image

Profile file is attached:


Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Ok, I will check this tomorrow. Both the standalone app and SSMS use the same parser. Interesting!


Reply
Page 2 / 3
Share: