SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Case when logic has too many or's
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cplusplus
Aged Yak Warrior

540 Posts

Posted - 08/26/2014 :  12:48:34  Show Profile  Reply with Quote
I want to write a case when logic with sum aggregation for Month_value.



these are the conditions i recv for DEPT_VISITS:
i tried to put this way within case when:

SUM(CASE WHEN Account =(88000400)
OR (PROG = 67900 and Account =88000000)
OR (PROD = 67900 and ACCOUNT=88000200)
OR (PROG=67900 and ACCOUNT=88000500) 
THEN mth_value)
END)  DEPT_VISITS,


Is the below logic better incorporating above conditions all:, please advise.

SUM(CASE WHEN Sub_Account =(88000400)  then mth_value
                  when PROG = 67900 and Account =88000000    then mth_value
                  when PROG = 67900 and ACCOUNT=88000200 then mth value
                  when PROG=67900 and ACCOUNT=88000500   then mth_value
               END)  
DEPT_VISITS,




Thanks a lot for the helpful info.

tkizer
Almighty SQL Goddess

USA
37165 Posts

Posted - 08/26/2014 :  12:51:12  Show Profile  Visit tkizer's Homepage  Reply with Quote
Don't you need an ELSE?

SUM(CASE WHEN (Account = 88000400) OR (PROG = 67900 AND Account IN (88000000,88000200,88000500))
THEN mth_value
END) DEPT_VISITS,

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

cplusplus
Aged Yak Warrior

540 Posts

Posted - 08/26/2014 :  12:59:35  Show Profile  Reply with Quote
Thank you Tara, I don't have else.
Go to Top of Page

ScottPletcher
Constraint Violating Yak Guru

USA
414 Posts

Posted - 08/26/2014 :  13:55:42  Show Profile  Reply with Quote
You don't need an ELSE. SQL will default it to NULL.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37165 Posts

Posted - 08/26/2014 :  14:13:38  Show Profile  Visit tkizer's Homepage  Reply with Quote
I didn't mean a mandatory ELSE, just a business rule/logic reason.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000