1 Reply Latest reply: Aug 16, 2011 9:24 AM by Anand Chouhan RSS

    help

    Kamal Naithani

      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:

       

      for eg:

       

      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?