We have the rates for different locations for different time intervals with TO and FROM dates being fed to us from the source system..
The reporting requirement includes reports which will be run for a specific time period and will have to display the MIN/MAX rates for every location in a specified period.
Say If report is run for Months JUNE and JULY..
We will have to take into consideration all the valid rates in that period and provide the min and max for every location..
I am just starting with the design..Your thoughts on achieving this would be highly appreciated and rewarded.