artful at rogers.com
artful at rogers.com
Fri Jan 12 09:49:20 CST 2007
Thanks for your reply. It appears from your reply and others that there is no modeling choice but to have a table recording the holidays of interest in the jurisdictions of interest. Then, using this table to metaphorically subtract those days from the date range of interest, we can then determine the number of business days between x and y. Arthur ----- Original Message ---- From: "Elam, Debbie" <DElam at jenkens.com> To: "dba-sqlserver at databaseadvisors.com" <dba-sqlserver at databaseadvisors.com> Sent: Friday, January 12, 2007 9:24:57 AM Subject: Re: [dba-SQLServer] Holidays by Nation and State/Province/Canton/ etc. There are state holidays in the US as well as national ones. For the most part, only State employees take the state holidays off. There are sometimes local holidays as well. Where I work, we have another office in the same state that takes a holiday for a local festival. To be fair, they probably could not get into the building that day anyhow. They have a street festival happening practically in their laps. Debbie -----Original Message----- From: artful at rogers.com [mailto:artful at rogers.com] Sent: Thursday, January 11, 2007 9:14 PM To: dba-SQLServer Subject: [dba-SQLServer] Holidays by Nation and State/Province/Canton/etc. I write this from Canada, wherein the days designated Holidays vary from province to province. Some Holidays are designated National and apply to all provinces. Other Holidays are local to the particular province of interest. Does the same thing apply to the USA? Are there, for example, holidays in Georgia that are not recognized in New York? Is there some definitive list of these that can be downloaded from someplace? Second, one assumes that this also applies to other nations. Let us take Switzerland as a hypothetical example. Are there holidays in Canton X that are not holidays in Canton Y? Gustav, what say you about Denmark? (I confess that I don't even know what a region of Denmark is called -- a province? a state? an enclave?) I think we have a few Dutch listers here too. What say you? Any French? Belgians? Italians? Spanish? Portuguese? Bulgarians? Serbians? etc. One assumes, based solely on the difference between Canada and the USA, that there are different national holidays and also "provincial" holidays. Can anyone supply more detail into this? TIA, Arthur TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com