I think if you have to group by all the fields you select. try select ... count(paycatid) as samepaycatid.... group by paycatid,employeeid, startdate, enddate
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 4:10 PM Subject: Re: SQL help please > Nope, that doesn't work. > > ----- Original Message ----- > From: laszlo <[EMAIL PROTECTED]> > Date: Wednesday, March 13, 2002 4:06 pm > Subject: Re: SQL help please > > > select ... count(paycatid) as samepaycatid.... group by paycatid > > > > laszlo > > > > > > [EMAIL PROTECTED] wrote: > > > > > Anyone? > > > > > > Bueller? Bueller? > > > > > > ----- Original Message ----- > > > From: [EMAIL PROTECTED] > > > Date: Wednesday, March 13, 2002 2:51 pm > > > Subject: SQL help please > > > > > > > Brain not working.... Must help... > > > > > > > > Here's my data set: > > > > > > > > employeeid startdate enddate paycatid > > > > ----------- ----------- ----------- ----------- > > > > 936 2002-02-08 2002-02-08 1 > > > > 936 2002-02-11 2002-02-11 1 > > > > 936 2002-02-12 2002-02-12 1 > > > > 936 2002-02-13 2002-02-13 11 > > > > 936 2002-02-14 2002-02-14 1 > > > > 936 2002-02-15 2002-02-15 1 > > > > 936 2002-02-18 2002-02-18 11 > > > > 936 2002-02-19 2002-02-19 11 > > > > 936 2002-02-20 2002-02-20 11 > > > > 936 2002-02-21 2002-02-21 11 > > > > 936 2002-02-22 2002-02-22 11 > > > > 936 2002-02-25 2002-02-25 7 > > > > 936 2002-02-27 2002-02-27 7 > > > > > > > > What I'm wondering is how do I get something like: > > > > > > > > employeeid startdate enddate same paycatid in a row paycatid > > > > ----------- ----------- ----------- ----------- ---------- > > > > 936 2002-02-08 2002-02-12 3 1 > > > > 936 2002-02-13 2002-02-13 1 11 > > > > 936 2002-02-14 2002-02-15 2 1 > > > > 936 2002-02-18 2002-02-22 5 11 > > > > 936 2002-02-25 2002-02-27 2 7 > > > > > > > > I'm using SQL Server 7. > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
