Posted by --CELKO-- on 03/04/07 15:41

SQL is a set-oriented language, not a computational language. Create
a table of reporting periods and use a BETWEEN predicate:

CREATE TABLE ReportPeriods
(period_name CHAR(7) NOT NULL PRIMARY KEY,
start_date DATETIME NOT NULL,
end_date DATETIME NOT NULL,
CHECK (start_date < end_date));

INSERT INTO ReportPeriods VALUES ('2007-01', '2007-01-01', '2007-01-31
23:59:59.99);
etc.

Now adjust the ranges to account for holidays, promotions etc.

[Back to original message]