11 Replies Latest reply: Dec 21, 2012 2:55 AM by Priya Joshi RSS

    Autogenerate?

    SIVASUBRAMANIAN KNK

      Hi all,

       

      I have the table like this,

       

      EmployeeNo

      FromDate

      ToDate

      Salary

      123

      1/1/2011 

      1/7/2011

      3000

      123

      1/8/2011 

      1/7/2012

      5000

       

      Now i want to create table like this,

       

      EmployeeNo

      Year

      Month

      Salary

      123

      2011

      Jan

      3000

      123

      2011

      Feb

      3000

      123

      2011

      Mar

      3000

      123

      2011

      Apr

      3000

      123

      2011

      May

      3000

      123

      2011

      Jun

      3000

      123

      2011

      Jul

      3000

      123

      2011

      Aug

      3000

      123

      2011

      Sep

      3000

      123

      2011

      Oct

      3000

      123

      2011

      Nov

      3000

      123

      2011

      Dec

      3000

      123

      2012

      Jan

      5000

      123

      2012

      Feb

      5000

      123

      2012

      Mar

      5000

      123

      2012

      Apr

      5000

      123

      2012

      May

      5000

      123

      2012

      Jun

      5000

       

      I have hundreds of employee numbers. Kindly all help me to solve this problem.

       

      Thanks and Regards,

      Sivasu