Posted by corey lawson on 10/20/05 18:51

Erland Sommarskog wrote:

> The two tables serves different purposes. The table with all the dates
> puts no attributes on the dates, and is only a help table for some
> operations. The other table lists only holidays. Neither that table
> has any other data beside the primary key, beside auditing data. But
> there is an important difference between the two tables, let's see if
> you can spot it!

Yes, using the second table with just holidays is a PITA. Flagging dates
in the calendar as various holidays is far easier to use. The list of
holidays can be derived from the calendar table easily enough.

[Back to original message]