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

Content with tag calendar Rss

   Items 1 to 11 of 11   
 

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,517 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2014/10/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 9,334 reads

Calendar Table by Month

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/09/16 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 1,810 reads

Calendar Table by Day

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/09/15 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 1,748 reads

Calendar Table by Day

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/09/15 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 1,748 reads

Calendar Table by Year

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/11 | Source: SQLServerCentral.com | Category: reporting
Rating: (not yet rated) |  Discuss |   Briefcase | 1,163 reads

Calendar Table by Month

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/09/16 | Source: SQLServerCentral.com | Category: reporting
Rating: |  Discuss |   Briefcase | 1,810 reads

Calendar Table by Interval Minutes

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2014/03/06 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,004 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,634 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,634 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2014/10/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 9,334 reads
   Items 1 to 11 of 11   
 
Tags
reporting (4)    
tally (4)    
date (3)    
holiday (2)    
calculate (1)    
complex (1)    
date manipulation (1)    
dimenson (1)    
parameterization (1)    
populate (1)    
reference (1)