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,594 reads

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By

 Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

Read the latest Blogs

Forums

Powershell extract

By Sqladmin1

$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...

Powershell extract

By Sqladmin1

$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...

Some query values change when query is run but not others. Why?

By water490

Hi everyone I have a 1000 line SQL query that is too long to...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers