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
2005-06-13 (first published: 2005-05-27)
274 reads
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, […]
2005-06-03
401 reads
By damianwidera
I have just written the fifth article of the Machine Learning topic. !!! This...
By Vinay Thakur
Working on Always On and configuration/setup of AG we have observed many errors. especially...
By Steve Jones
tl;dr For Windows when you need a different account. I had to work with...
I am trying to write a query that generates an html report to be...
HI Team, please help to get the expected data. my Data like below: create...
We are a product based company and using SQL Server as backend. Whenever there...
Ask SSC