Re: Simplifying db queries

In general they look like this:

CREATE TABLE ReportCalendar
(report_period CHAR(15 NOT NULL PRIMARY KEY,  start_date DATE NOT NULL,
 end_date DATE NOT NULL,
 CHECK (start_date < end_date));

You use a " my_date BETWEEN start_date AND end_date" search condition to create the report. Received on Fri Mar 04 2005 - 08:28:24 CST