Details

SQL calendar table

Speaker: Jim Horn

Duration: 70

Track: Database Development & Tuning

Demonstration of SQL Server T-SQL script that will build a calendar table, and demonstrate ways to easily query it to perform what would otherwise be complex date expressions.

Based on this article..
  (behind the paywall)  http://rdsrc.us/djrG6F
  (in front of the paywall)  http://www.experts-exchange.com/articles/12267/Build-your-own-SQL-calendar-table-to-perform-complex-date-expressions.html

Sequel articles for how to build customized calendars such as federal fiscal year, crop year, and a T-SQL date expression cheat sheet are in the works, and will be completed before SQL Saturday. 

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids