Todd,
Nice article. I also have large calendar tables to deal with - as one of my clients uses a rolling four week cycle starting the first saturday before February the 2nd, so as well as fiscal weeks to deal with I also have week 1-4 four each four week block! I too do not worry about optimising the SQL to populate this, as performance is not a considuration here, accuracy is.
Plus how come you get away with one page of forum questions where I have 4+ each time!
Look forward to more articles.
James
James
MCM [@TheSQLPimp]