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. > > > > > > > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
