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

198 reads

Blogs

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

SQL Server 2025

By

Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...

Advice I Like: Apologies

By

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Read the latest Blogs

Forums

Influencing a Local AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Influencing a Local AI

Data API Builder Operations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data API Builder Operations

SQL Clustered Resource in online pending for about 3-5 mins before coming online

By PJ_SQL

Hello! SQL Clustered resource used to come online during manual or automatic failover in...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers