Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1903

Re: How to keep a history of price for different ice cream in a dataware house

Show all headers | View raw

Dana nedjelja, 15. veljače 2015. u 18:02:34 UTC+1, korisnik Tony Johansson napisao je:
> 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

On my websites http://www.dbdesign10.com and http://www.dbdesign11.com you can find a solution that keeps "history".
This is the first and only correct general solution that solves the "History".

Vladimir Odrljin

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 18:02 +0100
  Re: How to keep a history of price for different ice cream in a dataware house Erland Sommarskog <esquel@sommarskog.se> - 2015-02-15 19:58 +0100
    Re: How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 21:38 +0100
      Re: How to keep a history of price for different ice cream in a dataware house Erland Sommarskog <esquel@sommarskog.se> - 2015-02-15 22:14 +0100
      Re: How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 22:30 +0100
  Re: How to keep a history of price for different ice cream in a dataware house rja.carnegie@gmail.com - 2015-02-16 03:51 -0800
  Re: How to keep a history of price for different ice cream in a dataware house --CELKO-- <jcelko212@earthlink.net> - 2015-02-16 08:37 -0800
  Re: How to keep a history of price for different ice cream in a dataware house gposta10@gmail.com - 2015-03-23 11:44 -0700

csiph-web