Assign standard Price-date

[ecabanas]

Hi,

I have this sales table with itemid, date and amount:

Salesid	Date	Itemid	units	Amount	Price
A	10/01/2015	1	1	2	3
B	15/02/2015	2	1	4	4,2
C	15/03/2015	4	1	5	5,2

And a Standard Cost table ordered by itemid, from, to, and Cost

Itemid	From	To	Price
1	01/01/2015	31/01/2015	3
1	01/02/2015	28/02/2015	3,2
1	01/03/2015	31/03/2015	3,3
2	01/01/2015	31/01/2015	4
2	01/02/2015	28/02/2015	4,2
2	01/03/2015	31/03/2015	4,3
3	01/01/2015	31/01/2015	5
3	01/02/2015	28/02/2015	5,1
3	01/03/2015	31/03/2015	5,2

And in a set analisys I want to match the itemid and date and choose the correct standard cost:

Many thank's

[swuehl]

HIC as written an excellent tech doc about slowly changing dimensions, like your price table:

IntervalMatch and Slowly Changing Dimensions