Help with nested Microsoft SQL Case Statment

jamesh1031
jamesh1031 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
ase WHEN (ChargeDays-TimeToSubtract > 9) THEN 1
           WHEN (ChargeDays-TimeToSubtract = 29) THEN 2
           WHEN (ChargeDays-TimeToSubtract >30) THEN 3 ELSE 0 END
Top Expert 2010

Commented:
CASE WHEN (ChargeDays-TimeToSubtract) > 9 THEN 1
      WHEN ChargeDays-TimeToSubtract = 29 THEN 2
      WHEN (ChargeDays-TimeToSubtract) > 30 THEN 3
      ELSE 0 END
Top Expert 2010

Commented:
slow fingers :)

Author

Commented:
Thank you all

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial