try
select employeeid, startdate, enddate, count(*), paycatid
from X
group by employeeid, startdate, enddate, paycatid
ksuh
@shaw.ca To: CF-Talk <[EMAIL PROTECTED]>
cc:
03/13/02 Subject: Re: SQL help please
04:51 PM
Please
respond to
cf-talk
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
