Why A Table of Dates?
I thought it would be nice to build on the numbers table with another very useful tool.
Dates are pretty important–especially if you are playing with data warehousing. Not only dates, but all the different properties and derived goodies contained within them. You really don’t need a dates table, unless you care about efficiency and getting to all the good stuff quickly. Perhaps I’ll showcase some of the “goodies” in later posts.
Sure, most databases have built-in functions to get everything you might want. But do you really want all the inefficiency that comes with calling functions and doing …[Read more...]