Re: Simplifying db queries

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 4 Mar 2005 06:28:24 -0800
Message-ID: <1109946504.659283.317460_at_o13g2000cwo.googlegroups.com>


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 - 15:28:24 CET

Original text of this message