simplistically in SQL
SELECT date,event
FROM events
WHERE date BETWEEN '1/14/2004' AND '2/16/2004'
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 10:33 AM
To: CF-Talk
Subject: Calendar query?
Does anyone know of a way to create a
11:34 AM
To: CF-Talk
Subject: RE: Calendar query?
simplistically in SQL
SELECT date,event
FROM events
WHERE date BETWEEN '1/14/2004' AND '2/16/2004'
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 10:33 AM
To: CF-Talk
To: CF-Talk
Subject: RE: Calendar query?
That would only give me the events in the database between the date range.
What I'm wanting is all dates between the range and any matching events in
the database.For my example the record set would be something like
ID | Date | Event
Sorry, rereading the question I didn't mention the fact that the database
only contains records that have events.The recordset I keyed in is what I
would like for a result set, not what is in the database.
Thanks for the suggestions!
Hatton
You can do an inner join on the same table then
Hi Hatton,
What works is to JOIN with a table that has all the dates for your range in
it, it will just display NULLs for the days that you dont have any matching
records.
If you do not have such a table in your database, create a temp table on the
fly...
This should work in SQL Server (notice
I provide an answer for this in another thread, my example was even based on a table of holidays just like you are looking for.As once mentioned, you can create in temporary table to join against the table with the dates.I did mine inline.This is an oracle base example, but I'm sure a similar
6 matches
Mail list logo