This discussion is archived
4 Replies Latest reply: Sep 10, 2013 8:46 AM by admin1 RSS

Combine multiple rows of table in single row

Thej Newbie
Currently Being Moderated


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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points