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: )

276 reads

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

401 reads

Blogs

New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

By

My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

https //ketomegamar com/vaso-prime-rx/

By lrisyjamtions

Vaso Prime RX Now for your method. Process specific exercises that you perform on...

Avamar Backup--Is it good?

By VastSQL

Dear Experts, is it good to use Avamar backup for SQL Server, currently we...

Read-only

By curious_sqldba

  I read MSFT documentation few times but couldn't find a clear answer. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers