Tags for case when multiple columns
Rewrite Case when statements
Hi,    I have a following query with multiple case when statements and i would need to performance tune it.   Request your help in re-writing this code.   Select  Case when (Table1.col2=Table2.col2) then Table1.Qty else Null end as AndJoinQty1
case when multiple columns
Adding count to a case when sum statement
I have the following CASE WHEN statement in my query and would like to get a count of each "category", so output would look something like this:  
count sum case when multiple columns