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,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