September 3, 2010 at 7:57 am
I got it .
((Contract_Type == "DS" ) && ( [Group/Name] != "") ? "DS" : (Contract_Type == "DC" ) && ( [Group/Name] != "") ? "E" : (Contract_Type == "DC" ) && ( [Group/Name] == "") ? "" :"Unknown")
Thanks All for your help .
September 4, 2010 at 12:27 am
PSB (9/3/2010)
I got it .((Contract_Type == "DS" ) && ( [Group/Name] != "") ? "DS" : (Contract_Type == "DC" ) && ( [Group/Name] != "") ? "E" : (Contract_Type == "DC" ) && ( [Group/Name] == "") ? "" :"Unknown")
Thanks All for your help .
Glad to help.
But when will Microsoft release a version with a derived column that allows multi-line statements? Because stuff like this is just painful to read...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2010 at 10:17 am
A switch/case statement would be nice too 🙂
Steve.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply