Right... I was creating dummy tables to eliminate all the extra columns/rows, but deleted them before I output some of the data. I'll run it up again to get...

tblProductPrice Data

price_id | product_id | effective_date | price

GUID | A | 6.99 | January 2012

GUID | A | 12.99 | May 2012

GUID | A | 18.99 | August 2012

GUID |...

CREATE TABLE [dbo].[tblProduct](

[product_id] [nvarchar](50) NOT NULL,

[product_name] [nvarchar](50) NULL,

[dtmStartDate] [date] NULL,

[dtmEndDate] [date] NULL,

CONSTRAINT [PK_tblProduct] PRIMARY KEY CLUSTERED

(

[product_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =...

I'll script it out tomorrow when I am back at that computer... but essentially what I am looking for is.

I have a bunch of products, all of which change prices...

Great thanks... now that I understand what I am looking for (the running total part), I see that there is a bunch of information out there.

Thanks again.