3 Replies Latest reply: Feb 24, 2017 2:42 AM by Silambarasan Manickam RSS

    Replacing values in the next record..??

    Silambarasan Manickam

      Hi All,

       

      I have table below mentioned.

          

      DATEBRANDPRODUCTRATE
      6/1/2016ABCSMPO5000
      6/1/2016DTCAPLE4300
      6/1/2016VGSCART2000
      6/1/2016CTGBEGTS7000
      6/1/2016OTSNTB9000
      6/2/2016ABCLPS3000
      6/2/2016DTCORG7500
      6/2/2016VGSONIN3000
      6/2/2016CTGSHTS9500
      6/2/2016OTSPEN1500
      6/3/2016ABCSMPO3500
      6/3/2016VGSTNTA5500
      6/3/2016DTCSTANE4500
      6/3/2016OTSNTB7000
      6/4/2016ABCHRDH6500
      6/4/2016DTCORG4000
      6/4/2016CTGPSNJ8000
      6/4/2016OTSNUS3700
      6/5/2016ABCLPS5600
      6/5/2016VGSBHA2200

       

      In this,

       

      I have some records on 6/1/2016. the same record to be there in the following dates. The price is as mentioned. If the same record not in the another date, then the Price values to be replaced before record value.

       

      Thanks.