Technical Article

IsDateAHoliday UDF

This is a User Defined Function that returns a 1 if date is a holiday else, it returns a 0.The holidays are:New years Day, MLK Day, Presidents Day, Memorial Day, Independance Day, Labor Day, Columbus Day, Veterans Day, Christmas Eve and Christmas Day

4 (1)

2005-06-13 (first published: )

281 reads

Technical Article

IsDateAHoliday UDF **NEW**

This is a replacement script for the first IsDateAHoliday. The first one was too slow and inefficient. This one is much better. Enjoy.IsDateAHoliday is a User Defined Function that accepts a date and returns a 1 if date is a national holiday and returns a 0 otherwise.The holidays are:New years Day, MLK Day, Presidents Day, […]

3.5 (2)

2005-06-03

403 reads

Blogs

Daily Coping 10 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

T-SQL Tuesday 153: The conference that changed everything

By

This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...

T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily

By

Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...

Read the latest Blogs

Forums

Retrieve username for report?

By joewkelly

We have a "report" that executes a stored procedure to perform updates. For these...

Transactional Replication to Azure getting "too many arguments" error on MSins

By Irish

I'm running a 2019 (15.0.4102.2) Server with Transactional Replication out to a SQL Azure...

Shrinking TempDb files or adding more files to TempDB?

By VoldemarG

We have 12 files in TempDb now (we added 4 a couple of months...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers