> current row = 1
> loop through your date range, day by day
> numrecords = 0
> output the current date
> loop while (using array notation) test and see if the date in
> record[current row] matches the current day
>numrecords = numrecords + 1
> end loop
>
Here's one idea in pseudocode
current row = 1
loop through your date range, day by day
numrecords = 0
output the current date
loop while (using array notation) test and see if the date in
record[current row] matches the current day
numrecords = numrecords + 1
sorry, not an ounce of Oracle knowledge... good luck with it though
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 28 October 2003 12:41
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Quick query question...
> Could you do this by building a dates table
> Could you do this by building a dates table and joining to that? I
remember
> in a previous company having such a set-up when we regularly used a
dates
> table made up of columns such as DDMM, MMDD, Period, Month etc
etc..
>
> I appreciate am lot of this has been superseded by dateformat
the
like, but I think it would give you to result you require? Better than
looping through each date and running a separate query
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 28 October 2003 11:58
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Quick query question
I've got some date-based data where, on some days, there are no records
in the table. I'm summing the number of records for each day and want to
end up with a recordset along the lines of:
DateTotal
1/1/20035
2/1/20036
3/1/20030
4/1/20036
As some days h
