Rob Scholl

SQLServerCentral Article

Finding the Next Business Day Recursively

How do you find the next business day? What is a next business day? Holidays, country specific issues, etc. all come into play with many business functions and it can be a complicated process. New author Rob Scholl brings us a recursive function in TSQL to help solve this problem.

5 (1)

You rated this post out of 5. Change rating


13,439 reads


FDD 2023 – Session Materials


You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger


I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission


Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

Read the latest Blogs


Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers