kmpel
@kmpel
Member
Joined: Dec 3, 2025
Last seen: Feb 6, 2026
Topics: 5 / Replies: 8
Reply
RE: SELECT TOP - first column name below

The recent 2026-01-29 version moves the first column to the second row. But Top N stays before the column name, which is less readable. Is there any c...

1 month ago
Reply
Topic
Replies: 1
Views: 32
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

Hi Guido, thank you for working on this. I check it out. I think working out when to align operators, such as the plus sign (+), is a tough logic prob...

1 month ago
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

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. Pleas...

1 month ago
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

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 se...

1 month ago
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

Thank you for your reply. Is there any chance of implementing the ideal solution as per the sample below? --IDEAL SOLUTION, including subselect in r...

1 month ago
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

Sorry, I have one more if, isnull or built-in function strange behaviour.msql, profile:jr6 SELECT LocalAmount = @AmountOnAccount ,L...

1 month ago
Reply
RE: How to keep short IIF functions on one line in SELECT clauses?

I found the solution by myself for iif:In MyLists: add iif into and set line to 10, next lines: 1 However, there is stillan option that some built-...

1 month ago
Topic