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)
276 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 Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Comments posted to this topic are about the item Automatic Redaction of PII
I have a table with a varchar field. It contains a number of characters...
I'm creating a table to store serialized shopping cart data associated with a user...
Ask SSC