Query limiting values by 'valid from'

[#1]

Hi,

this is what I would like to realise:

Query limiting values for a dataset depending on the time range when these are valid.

Examplel:

Table A (Data):

Name                Date                  Value

System1           01.10.2011          91

System1           02.10.2011          92

System1           03.10.2011          91,5

System1           04.10.2011          93

Table A (Limiting values):

Name                Date_B               Value_B

System1          01.10.2011          90

System1          03.10.2011          95

Expected result:

Table C (results):

Name                Date                  Value            Value_B

System1           01.10.2011         91                 90

System1           03.10.2011         91,5              95

System1           04.10.2011         93                 95

Thank's for your help.

[lironbaram]

hei

attach is an example

the logic is in the load script to connect evry record to the correct value_b

this i achive using interval match

hope it helps you