Technical Article

IsWorkday UDF without a table

While the other methods for calculating holidays ect use a table to store the holidays, this inline UDF goes the opposite route, by returning 1 if the given date is a weekday that also does not fall on a number of holidays.  Examples shown allow for easy extension to other holidays as deemed necessary.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-05-02

222 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

By

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

PostgreSQL 19 Is Late

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PostgreSQL 19 Is Late

Hyperscale Replicas V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas V

A Heavy Heart

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Heavy Heart

Visit the forum

Question of the Day

Hyperscale Replicas V

I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?

See possible answers