Your production environment needs Date and Number tables, to help you Get Stuff Done in sets instead of RBAR*.
Doug Lane has a video on Why You Simply Must Have a Date Table. I really loved the intro.
A Numbers Table is also very useful for similar reasons. Jeff Moden has been harping on about so-called Tally Tables for years.
Check out Greg Larsen’s post, Creative Solutions by Using a Number Table, for some nifty uses.
- Jeff Moden coined the acronym RBAR, or Row By Agonizing Row.