SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag holiday Rss

Search for any content tagged holiday

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 4 of 4   
 

Compute Holiday Day of the Month for any Year

This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.  Read more...
By Eric Notheisen 2017/05/24 | Source: SQLServerCentral.com | Category: date computation
Rating: (not yet rated) |  Discuss |   Briefcase | 240 reads

Calendar Table Function

This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently  Read more...
By Chris Kutsch 2016/08/02 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 4,549 reads

Create bank holidays table

Do you know what happens if a holiday falls on a weekend? This script will help you.  Read more...
By Scott Thomas, AAP 2012/01/16 | Source: SQLServerCentral.com | Category: holiday
Rating: |  Discuss |   Briefcase | 1,939 reads

Calculate U.S. Holidays

This script runs off the Date Calendar table to flag is_workday when your business is closed for holiday.  Read more...
By Boyd Tyrrell 2011/07/01 | Source: SQLServerCentral.com | Category: holiday
Rating: |  Discuss |   Briefcase | 2,818 reads
   Items 1 to 4 of 4