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)
286 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
410 reads
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
By Brian Kelley
After I have understood the details for a certification test (part 1), including format...
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Hello, I am working with a company on their database administration. I am trying...
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers