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)
939 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)
455 reads
Blogs
Using Write-Debug
By Steve Jones
I wrote a post about PoSh output recently, noting that in general we ought...
T-SQL Tuesday Retrospective #002: A Puzzling Situation
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...
Daily Coping 28 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Stored Proc with OPENJSON: How to determine insert or update?
This is my 1st attempt at openjson & I'm trying to setup a stored...
product version result
SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I need to...
Login to SQL Server cross domain AD Group user
Our MS SQL Server is on another trusted domain (Trusted Domain T). We created...
Ask SSC