home bbs files messages ]

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