Reading about it now - very cool! Always thought that was restricted to MDX queries.

Sergey, you are a good tip dude.


>There's CASE function in T-SQL than provide the same functionality but is even more powerfull than IIF().
>
>>One thing you will see is that you would give your right leg to have an T-SQL equivalent
>>of IIF(). NVL() it has: ISNULL().
>>