Details

SQL calendar table

Jim Horn
70
Database Development & Tuning
Beginner
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