On Wed, Sep 16, 2009 at 5:54 AM, Stephen Weeks <[email protected]> wrote: > I had a similar need, I created a calendar table with production week > number, from date, to date, financial week number etc and they wanted to > store budget figures against each week for each geographical region so > that works for me. ------------------------------
You need to read about dimension table data. <http://tinyurl.com/r8ukxq> Look for this section, "Normalized versus dimensional approach for storage of data" First thing is to start getting your dates straight on the front end. Then you can focus on having them stored properly in the fact tables will really help for times like these. A little planning really makes things easier. This will be done on a ONE TIME basis per row of fact data, Sales order, invoice, etc. You will no longer be doing this for EVERY REPORT. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
