Re: SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
DOH!! end of the day, yeah... cc.cc_type_id isn't part of a group by or aggregate function.. and I need those end values as part of the returned record set On 12/13/2012 4:49 PM, John M Bliss wrote: > This gives you the error...? > > CASE > WHEN cc.cc_type_ID = 1 THEN @careCB + 1 > WHEN cc.cc_ty

Re: SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
Except I need those values individually as part of the return.. On 12/13/2012 4:49 PM, John M Bliss wrote: > This gives you the error...? > > CASE > WHEN cc.cc_type_ID = 1 THEN @careCB + 1 > WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 > WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 > WHEN cc.cc_type_ID =

Re: SQL Question, incrementing values

2012-12-13 Thread John M Bliss
This gives you the error...? CASE WHEN cc.cc_type_ID = 1 THEN @careCB + 1 WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 ELSE 0 END AS myvar On Thu, Dec 13, 2012 at 3:45 PM, Sco

SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
Hey all I have a couple of questions with a query that I'm trying to put together What I need as part of this query is a running count of applications that each value of cc_type_id (there's five). I'm trying to do it in the CASE statement below, however if I try to use AS something in order to