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

Erland Sommarskog wrote:

> --CELKO-- (jcelko212@earthlink.net) writes:
>
>>>>Thanks Erland for your assistance on populating the dates table, but
>>>>that seems a very complicated way to do it. <<
>>
>>Could you please show us the portable, un-complicated code for
>>determining Easter, Chinese New Year and the Jewish holiidays? The
>>150+ fiscal calendars under GAAP?

Store them in a table. Why bother calculating them? It's not worth the
effort.

>
>
> I don't think that he was asking for. He only wanted the days flat out,
> no mention of holidays or anything.

Yep, and the simplest way to do this is to create a table just with
dates in it from 1/1/2000 to whenever, like JCelko pointed out.

>
>>Build a calendar table with one column for the calendar data and other
>>columns to show whatever your business needs in the way of temporal
>>information. Do not try to calculate holidays in SQL -- Easter alone
>>requires too much math.
>
>
> And he didn't have the privs to create tables.

So what? Shouldn't he be able to ASK someone with the privs to get the
table created? It has worked well for me in the past as a contractor at
other companies...

> Rather than using canned rants, try to read people posts. If you ever
> care to be helpful, that is.

Whatever floats your boat...

[Back to original message]