Thank this author by sharing:
By Arsen Serobian, 2010/11/22
1. This function returns previous business day of the date parameter passed to function. It takes into consideration weekends & holidays.2. To properly use this function make sure the <Holidays> table with <holiday_date> field contains all annual holidays which should be manually entered into table3. This function assumes that the week starts on Sunday (USA version)
A table UDF to return a list of holidays for a given year.
T-SQL Function to Determine Holidays in SQL Server
I need to find a way to skip holidays for a scheduled job.
Merry Christmas and Happy Holidays from SQLServerCentral
A way to save holiday records that can be created as needed into a search-able calendar table.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
