Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
1,184 reads
Date computation
2018-02-23 (first published: 2018-02-19)
124 reads
2017-12-29
1,070 reads
Compute Holiday Day of the Month for any Year
This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.
2017-05-24 (first published: 2017-05-10)
463 reads
Blogs
Daily Coping 15 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Another One Bites the Dust - PASS is Gone, so...What Now?
There has been a lot of noise over the last few weeks since it...
SQL Server Linux
By Arun Sirpal
If you have come from a windows background you may be curious about the...
Forums
Newbie; Unsure where to Start?
Hi, First time poster, and hoping everyone goes easy on me. I am very...
DB corruption error 8905, fixed using repair_allow_data_loss ,
hi all, I need some help here. Recently, I've found a db with error...
Ask SSC