Michael Coles: Sergeant SQL : SQL 2008, holidayshttp://sqlblog.com/blogs/michael_coles/archive/tags/SQL+2008/holidays/default.aspxTags: SQL 2008, holidaysenCommunityServer 2.1 SP2 (Build: 61129.1)Calculating Holidays in SQLhttp://sqlblog.com/blogs/michael_coles/archive/2010/02/25/calculating-holidays-in-sql.aspxThu, 25 Feb 2010 21:51:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22626Mike C4http://sqlblog.com/blogs/michael_coles/comments/22626.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=22626http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=22626Ask about nearly any kind of SQL-based date calculation in the newsgroups , and you'll likely get responses that include use of an auxiliary calendar table . It's a really good idea, and something I highly recommend to anyone who has to do date-based...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2010/02/25/calculating-holidays-in-sql.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=22626" width="1" height="1">SQLSQL Server 2008SQL Servert-sqlSQL 2008functionssql 2005floating holidaysauxiliary date tableholidays