4 Replies Latest reply: Sep 10, 2013 10:46 AM by admin1 RSS

    Combine multiple rows of table in single row

    Thej


      Hi Experts,

       

      I have a table of below format.

       

      MSDNIDWALL_BALWALL_DATE
      1233406-Sep-13
      1235607-Sep-13
      1237808-Sep-13
      1236509-Sep-13
      1233410-Sep-13
      1238711-Sep-13

       

      Now I have to create a new table. which should contain unique MSDNID with WALL_BAL in different column .

       

      Like below

      MSDNIDDAY1_BALDAY2_BALDAY3_BALDAY4_BALDAY5_BALDAY6_BAL
      123873465785634

       

       

      How can I write a query for this?