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

2005-11-03

13,536 reads

Blogs

Migrate to Azure PostgreSQL Flexible Server

By

I need to migrate from a single server to a flex server. Instead of...

Using Copilot to help me update SQL Saturday

By

An interesting AI experiment here with Copilot from GitHub in handling some code I...

Master SQL with This Free Course (141 Interactive Exercises Included)

By

SQL is essential for modern businesses and applications that rely on data. It's a...

Read the latest Blogs

Forums

The Vast Expansions of Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Vast Expansions of Hardware

Code Blocks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Code Blocks

does netsuite really hide columns from customers?

By stan

Hi we built a gateway from sql server to netsuite using an oracle competitor's...

Visit the forum

Question of the Day

Code Blocks

What happens with this code:

DECLARE @Iteration INT = 0;

WHILE @Iteration < 10
    SELECT CustomerName,
        CustomerStatus
    FROM dbo.Customer
    WHERE CustomerID > 3;

    SET @Iteration += 1;

See possible answers