I have used IIF if I think:

1. The arguments are not going to scale - if it becomes more than True/False, or the evaluation of the condition is complex in...

I hadn't heard the term but have been doing this for some time as well. It's saved my biscuits MULTIPLE times because a lot of operational work, even inside the...

You can also do simple wraps/nests right in the source query. Think of it as an action on the data in the table that you've wrapped (in this case, table...