|
|
Posted by Erland Sommarskog on 10/12/05 13:58
--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?
I don't think that he was asking for. He only wanted the days flat out,
no mention of holidays or anything.
> 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.
Rather than using canned rants, try to read people posts. If you ever
care to be helpful, that is.
--
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
Navigation:
[Reply to this message]
|