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

279 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

402 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

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

Read the latest Blogs

Forums

SQL Server 2019 PMEM

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2019 PMEM

Query Optimizer Suggests Wrong Index and Query Plan -- Why?

By Mike Byrd

Comments posted to this topic are about the item Query Optimizer Suggests Wrong Index...

UX Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item UX Matters

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers