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,171 of 19,505    |
|    rja.carnegie@gmail.com to Tony Johansson    |
|    Re: How to keep a history of price for d    |
|    16 Feb 15 03:51:15    |
      On Sunday, 15 February 2015 17:02:34 UTC, Tony Johansson wrote:       > 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              How did the horse meat go?              --- 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