Details

SQL calendar table

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.

Brought to you by your local PASS Community

Connect

SQLSaturday is a trademark of PASS. Have a question about the site? Contact Us