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

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

X-Received	by 10.182.246.198 with SMTP id xy6mr696120obc.26.1427136268034; Mon, 23 Mar 2015 11:44:28 -0700 (PDT)
X-Received	by 10.140.101.148 with SMTP id u20mr9005qge.5.1427136268008; Mon, 23 Mar 2015 11:44:28 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!z20no2524265igj.0!news-out.google.com!q90ni528qgd.1!nntp.google.com!z107no4357915qgd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Mon, 23 Mar 2015 11:44:27 -0700 (PDT)
In-Reply-To	<mbqjdu$32o$1@dont-email.me>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=77.237.109.197; posting-account=GkmQDwoAAACufsQ7SBEEfQqOinAuwmaY
NNTP-Posting-Host	77.237.109.197
References	<mbqjdu$32o$1@dont-email.me>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<ac04c16d-4622-436a-94c4-a3cc29ee0e33@googlegroups.com> (permalink)
Subject	Re: How to keep a history of price for different ice cream in a dataware house
From	gposta10@gmail.com
Injection-Date	Mon, 23 Mar 2015 18:44:28 +0000
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1903

Show key headers only | 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