1
Answer

How to implement PIVOTING with dynamic no of rows ?

Jagan Mohan

Jagan Mohan

11y
1k
1

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)