Aug 01, 2018 11:55 AM|me_ritz|LINK
Seems to be working fine. Btw, what is the name of this trick/approach when the CASE is "practically" not part of the expression so you use 1 and 0 ???
It doesn't have a name.
It's like SELECT * FROM TAB WHERE 1 = 1, and you get all rows from the table. I just used CASE statement to decide when to return 1 or 0, so you get desired rows.
P.S. Is it maybe a NESTED CASE ?
No, It's not.