I was wondering if there already existed a table in the impresario db with every date of the year, instead of me creating one? I'm building a sales tracker in SSRS and would love to join it to every date so as to avoid missing dates in my graph. I would love to know if this exists somewhere.
Thanks,
Stephen
Paul's suggestion is great, however I created a static LT_CALENDAR table here at the Guthrie which I use frequently for all sorts of reporting purposes. I cribbed many ideas from this blog post:
http://www.brianshowalter.com/calendar_tables
Thank you both for replying, I think I will go ahead and create a local table as I can see needing to use frequently. This blog post is great.