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

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

X-Received	by 10.182.251.231 with SMTP id zn7mr21811607obc.24.1424087475939; Mon, 16 Feb 2015 03:51:15 -0800 (PST)
X-Received	by 10.140.28.11 with SMTP id 11mr267283qgy.21.1424087475903; Mon, 16 Feb 2015 03:51:15 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!hl2no11848784igb.0!news-out.google.com!c1ni6qar.1!nntp.google.com!j7no901739qaq.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Mon, 16 Feb 2015 03:51:15 -0800 (PST)
In-Reply-To	<mbqjdu$32o$1@dont-email.me>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=194.83.173.135; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
NNTP-Posting-Host	194.83.173.135
References	<mbqjdu$32o$1@dont-email.me>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<320e351a-17f5-4d03-8c21-be71853ce23f@googlegroups.com> (permalink)
Subject	Re: How to keep a history of price for different ice cream in a dataware house
From	rja.carnegie@gmail.com
Injection-Date	Mon, 16 Feb 2015 11:51:15 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1893

Show key headers only | View raw

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?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next 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