
A date (or calendar) table is a SQL table containing a variety of date-related parameters. By joining to this table, one can rapidly access the pre-calculated values, thus significantly simplifying & speeding up your queries. Using 18 December 2013 as an example, the following parameters would be available: Parameter Value Date … [Continue reading...]