none
COnvert my data using T-sql RRS feed

  • Question

  • Hi Team,

    My table data below

    DEP EMP MONTH1 AMOUNT_MONTH_1 MONTH2 AMOUNT_MONTH_2 MONTH3 AMOUNT_MONTH_3
    AA A 2020-7 2000 2020-8 1000 2020-9 700
    AA B 2020-7 1200 2020-8 900 2020-9 800
    AA c 2020-7 600 2020-8 800 2020-9 700

    Below is my expected output

    DEP EMP 2020-7 2020-8 2020-9
    AA A 2000 1000 700
    AA B 1200 900 800
    AA c 600 800 700

    Friday, September 25, 2020 1:40 PM