artful at rogers.com
artful at rogers.com
Fri Jan 12 09:59:29 CST 2007
A walk down memory lane! When I was a child, and also a meat-eater, Canada Day was celebrated by eating buffalo burgers in the parking lot of a big-box grocer called Loblaws. Now I eat no meat, but I do recall buffalo burgers. Anyway, it seems clear that the only way to deal with the problem of BusinessDays is to have a table recording all the holidays local to a region, and then to link said region to a Regions table (since a given company might well have branches in many regions). Arthur ----- Original Message ---- From: Mark A Matte <markamatte at hotmail.com> To: dba-sqlserver at databaseadvisors.com Sent: Friday, January 12, 2007 10:19:32 AM Subject: Re: [dba-SQLServer] Holidays by Nation andState/Province/Canton/ etc. I'm originally from Lafayette Louisiana...and growing up...we had almost a week out of school for Mardi Gras...and most definetely the local businesses closed...unless they served food or drink. I've lived in many different US states...there are different Holidays for different cities, much less the states. Now that I'm typing it...I remember in Louisiana, the following cities would have the following 'holiday'/festival that would pretty much encompass the whole community: Breaux Bridge...the Crawfish Festival Crowley...the Rice Festival Raine(where I was born)...The Frog Festival And these are just a few that I remember. I think there is no set guidelines...I mean a company could even create its own 'private' holiday where they just pick a day and close up shop. Seems like there is no logic to be applied. Not sure if it answers anything, but a walk down memory lane for me. Thanks, Mark A. Matte >From: "Elam, Debbie" <DElam at jenkens.com> >Reply-To: dba-sqlserver at databaseadvisors.com >To: "'dba-sqlserver at databaseadvisors.com'" ><dba-sqlserver at databaseadvisors.com> >Subject: Re: [dba-SQLServer] Holidays by Nation >andState/Province/Canton/ etc. >Date: Fri, 12 Jan 2007 08:24:57 -0600 > >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 > _________________________________________________________________ The MSN Entertainment Guide to Golden Globes is here. Get all the scoop. http://tv.msn.com/tv/globes2007/?icid=nctagline2 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com