Just another handy code snippet for generating dates for date dimensions in your data warehouse.
I am providing just the select statement here, but to generate (massive) date records, just create and set your start and end date variables, and enclose your insert and the code below in your WHILE loop.
4 Comments