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

Reply via email to