|
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?
Navigation:
[Reply to this message]
|