I dont know about your "indexing" question, but i will suggest an alternative way of solving your initial problem:
I have an input table with these columns:
Product_id, Year, Quarter, Turnover
and this table can be denormalized into this table
Product_id, Year, Turnover_Q1...
Hi.
This problem is only solved with a difficulty without a "date-table". (helpful in many situations)
1) Create a table with these columns (arbitrary-sample data included - fill out for the next 5 years or so...)
date | dayofweek | Holiday | Weekend
29.12.2000 | thu |...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.