jamesh1031
asked on
Help with nested Microsoft SQL Case Statment
Can you help me with this. It is currently unable to parse.
Case WHEN (ChargeDays-TimeToSubtract > 9) THEN 1 ELSE CASE WHEN (ChargeDays-TimeToSubtract = 29) THEN 2 ELSE CASE WHEN (ChargeDays-TimeToSubtract >30) THEN 3 ELSE 0 END
Case WHEN (ChargeDays-TimeToSubtract
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
slow fingers :)
ASKER
Thank you all
WHEN ChargeDays-TimeToSubtract = 29 THEN 2
WHEN (ChargeDays-TimeToSubtract
ELSE 0 END