Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag holiday Rss

   Items 1 to 5 of 5   
 

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 2015/01/07 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,836 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,847 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,647 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,647 reads

Riddle Me This

By Jason Brimhall 2009/12/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,939 reads
   Items 1 to 5 of 5   
 
Tags
calendar (2)    
date (2)    
bank (1)    
cte (1)    
date manipulation (1)    
federal reserve (1)    
humor (1)    
recursion (1)    
t-sql (1)