using sum to eliminate records

[sap1958]

select giftid,
sum(case when gifteffdat >'7/1/2009' then giftamount else 0)end as FY11

from gifttable
where [FY11] = 0
group by giftid

I tried using FY11 = 0 and get an error message. I am trying to use the FY11 to eliminate records based on the date range. Can I do this or must I repeat the sum(case formula at the bottom after the group by

I am using SQL 2005

 

[SkipVought]

Hi,

Why are you summing a DATE? What does that mean, addin dates?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[djj55]

Skip he is using giftamount in the sum

As the query is shown the parenthesis is on the wrong side of the end

sum(case when gifteffdat >'7/1/2009' then giftamount else 0)end 
-- Should be
sum(case when gifteffdat >'7/1/2009' then giftamount else 0 end[b])[/b]

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[markros]

select giftid,
sum(case when gifteffdat >'7/1/2009' then giftamount else 0 end) as FY11

from gifttable

group by giftid
having sum(case when gifteffdat >'7/1/2009' then giftamount else 0 end) = 0

PluralSight Learning Library