Jeff Moden (11/5/2012)
Nah... you didn't mislead. I forgot to include the column name being checked by the case statement. You picked up on that correct, it would appear.For your output, just alias the CASE statement with columnname = CASE .... and you should be all set.
Forgive me for being obtuse but...
Does this mean there will always be two columns though? Or is there a way to have just one column with the minus prefix when the conditions of the CASE statement are met?
(Really appreciate this help, by the way. 🙂 )