wildh (9/23/2010)
Is this any good - http://facility9.com/2009/04/23/populating-us-federal-holidays-in-a-calendar-table/or -
We have a similar issue in the UK but it's only a 10 min job to crib it from a web site into a update script. But hang on, then it's a 4 month wait for the DBA's to run it.
Yup, that's basically the T-SQL I ended up writing. If you want to be picky, there is also a US law that gives federal employees a holiday for presidential inaugurations but only in certain jurisdictions near Washington DC. There are also unplanned holidays like when Gerald Ford dies.