Link to home
Start Free TrialLog in
Avatar of jamesh1031
jamesh1031Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
CASE WHEN (ChargeDays-TimeToSubtract) > 9 THEN 1
      WHEN ChargeDays-TimeToSubtract = 29 THEN 2
      WHEN (ChargeDays-TimeToSubtract) > 30 THEN 3
      ELSE 0 END
slow fingers :)
Avatar of jamesh1031

ASKER

Thank you all