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.

2004-05-02

193 reads

Blogs

Azure SQL Database – Error Logs?

By

Ok, so Azure SQL doesn’t really have its own error log based somewhere on...

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

For loop in C# script component

By rohitkocharda

Hi Everyone,I have a script task calling a sequence container. What i would like...

More Time to Certify

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Time to Certify

Difference Between Lists

By BTylerWhite

Comments posted to this topic are about the item Difference Between Lists

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers