Counting groups of Date Ranges
From: Shayler Rychlick (shaylerr_at_netzero.com)
Date: 03/29/04
- Next message: Terry: "Re: checking for error following an UPDATE"
- Previous message: R. Daneel Olivaw: "How to get XML from SQL Server"
- Next in thread: Vitali Kalinin: "Re: Counting groups of Date Ranges"
- Reply: Vitali Kalinin: "Re: Counting groups of Date Ranges"
- Reply: Ray Marron: "Re: Counting groups of Date Ranges"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 29 Mar 2004 11:15:47 -0500
I am using Delphi7 Ent. I have a Table full of data with a datetime field
on each record. I am trying to determine the best way to count all of the
record that have a date of Jan, then all the record with dates in Feb.....
then all the dates in Dec. Currently I am running 12 different quieries for
each of the 12 months.
ex. " Select Count(*) as Jan from Table1 where Date > '12/31/03' and Date <
'2/01/04' ".
" Select Count(*) as Feb from Table1 where Date > '1/31/04' and Date <
'3/01/04' ".
Does anyone know of a different way of doing this task.
- Next message: Terry: "Re: checking for error following an UPDATE"
- Previous message: R. Daneel Olivaw: "How to get XML from SQL Server"
- Next in thread: Vitali Kalinin: "Re: Counting groups of Date Ranges"
- Reply: Vitali Kalinin: "Re: Counting groups of Date Ranges"
- Reply: Ray Marron: "Re: Counting groups of Date Ranges"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]