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

274 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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

CAST FOR XML - Illegal Name Character

By jamie_collins

I am trying to write a query that generates an html report to be...

Get the inactive records in sqlserver

By kbhanu15

HI Team, please help to get the expected data. my Data like below: create...

Revert a database to a DB Snapshot

By Chimney

We are a product based company and using SQL Server as backend. Whenever there...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers