Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,166 of 19,505    |
|    Tony Johansson to All    |
|    How to keep a history of price for diffe    |
|    15 Feb 15 18:02:13    |
      From: johansson.andersson@telia.com              Hello!              Assume I have a table called Sales in the dataware house where we have the       four columns Month, Ice cream, City and quantity.       We have three dimensions where we have Month, Ice cream and City.       It could look like this       Sales table       Month Ice cream City Quantity       January Päronsplitt Stockhomn 3       January Top hat Göteborg 7       January Smugler Malmö 13                     Now to my question. It is important to keep historic data in the dataware       house.       So assume that I want to keep history of the price that have been existing       on different ice cream how       would this be structured in the sales table.              //Tony              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca