Posted by Erland Sommarskog on 10/21/05 00:23

corey lawson (corey.lawson@ayeteatea.net) writes:
> 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.

No. Well, in the case you only care about one country, it is. We need
to keep track of non-business days in several countries.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
• Prev in forum: historical data
• Thread view: Re: Dates in a date range

[Reply to this message]