Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 US Holiday Table

Author  Topic 

Zim327
Yak Posting Veteran

62 Posts

Posted - 2009-04-30 : 17:03:21
I was wondering if anyone out there already has a table with US federal holidays loaded into it? (a list of 2009 holidays and beyond would be ideal)
If so, could you please export it all and send it to me?
That would be a tremendous help to me as I'm on a tight schedule with limited resources.

(it never hurts to ask, right?)
Thank you,



Best regards,
Zim
(Eternal Yak God Emperor from the Future)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-30 : 17:17:19
It took me all of five seconds to find this: http://facility9.com/2009/04/23/populating-us-federal-holidays-in-a-calendar-table/

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Zim327
Yak Posting Veteran

62 Posts

Posted - 2009-04-30 : 17:28:32
Holy Carp!! That was fast.
My google-fu is weak.
I salute your superior skills! (seriously, I do!)

Thanks a million!

Best regards,
Zim
(Eternal Yak God Emperor from the Future)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-30 : 17:47:01
You're welcome.

Here's what I typed into the Google search: US federal holidays 2009 sql table.

It was the first link.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-05-04 : 16:34:42
quote:
Originally posted by Zim327

Holy Carp!!



Hee-hee, "Holy Carp Batman"

quote:
Originally posted by Zim327

(Eternal Yak God Emperor from the Future)



No self-proclaimed titles (unless you're sir flump!)....and a "God" no less....


Terry

-- Procrastinate now!
Go to Top of Page

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2009-05-06 : 15:06:06
What is the structure of that Calendar table?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-06 : 20:49:41
It was in Tara's link, but one link removed:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html
Go to Top of Page
   

- Advertisement -