I wanted to know the solution of following scenario:
There is a table T1 which has Fields code,year,month,value.
For each code for each year,there are 1 or more values:
code year month value
1 2010 1 20
1 2010 6 25
if there are no changes in the value for that partucular year, the value
should be same from that particular month till the end of that year.If there
are changes in any particular month,then the value should take effect from
that month till the end of the year.
How to code this?