Jagan Mohan

Jagan Mohan

  • NA
  • 19
  • 57.1k

How to implement PIVOTING with dynamic no of rows ?

May 8 2013 7:33 AM

Name

Points

A

100

B

200

C

300

A

400

B

500

C

600

A

700

B

800

C

900

……..

……

………

……..

……..

……..

……..

……..

                

Now I need to know how to get the following format output in SQL Server                                  

             A

                    B

                 C

           ----------

 100,400,700,…

200,500,800,…..

300,600,900,…..

          -----------

 

 


Answers (1)