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)
749 reads
Date computation
2018-02-23 (first published: 2018-02-19)
122 reads
2017-12-29
1,069 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)
448 reads
Blogs
Covid Thoughts, So Far
By Andy Warren
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...
How to Think Like a Certification Exam at the PASS Professional Development Virtual Group
By Will Assaf
Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...
Deploy BACPAC to Azure Managed Instance failing from SSMS?
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Forums
Query help for special condition
Hi sql gurus, I am currently doing some R&D on MERGE statement and as...
Going Back to the Basics
In the past couple months, I have helped people understand a handful of topics...
Advantages and Disadvantage using Temp Table or Fisical Table
Please share your thought about advantages and disadvantages for processing using temp table or...
Ask SSC