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.
No material found.