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

Scripts with tag calendar Rss

Search for any content tagged calendar

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 7 of 7   
 

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 | 2,502 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,232 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,857 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,841 reads

Calendar Table by Interval Minutes

Populate a calendar table with user set interval start and end datetime values.  Read more...
By Marie Bayer 2015/03/24 | Source: SQLServerCentral.com | Category: calendar
Rating: |  Discuss |   Briefcase | 1,025 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,699 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,591 reads
   Items 1 to 7 of 7