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)
2,212 reads
Date computation
2018-02-23 (first published: 2018-02-19)
130 reads
2017-12-29
1,071 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)
468 reads
Blogs
Daily Coping 17 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Ethics in Modern Data at Music City Tech 2021
By Will Assaf
On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...
Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available
Last week, Kerry and I delivered a webinar with tips on how to set...
Forums
Log Shipping Truncate Log File
Good Morning, I have read that taking a log backup truncates the log file....
Azure SQL Migrations using Azure Data Studio
Comments posted to this topic are about the item Azure SQL Migrations using Azure...
Poor Work Management
Comments posted to this topic are about the item Poor Work Management
Ask SSC