Posted by metaperl on 07/11/06 20:38

Erland Sommarskog wrote:

>
> CREATE TABLE tradingdays (date datetime NOT NULL,
> dayno int NOT NULL,
> CONSTRAINT pk_tradingdays PRIMARY KEY (date),
> CONSTRAINT u_tradingdays UNIQUE (dayno))
>
> That is a table that maps a day to a number. The rest is easy.

I'm not following this.

- how would this table be populated and what with?
- how does the day number tell you that a day is not a weekend or
holiday?

[Back to original message]