| 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,….. | ----------- |
Rajmendra RawatPosted May 13, 2013, 10:14 AM
SELECT @COLUMNS=',['+Name+']' FROM TABLE NAME with xml path(' ')
SET @COLUMNS=STUFF(@COLUMNS,0,1,',')
exec('SELECT * FROM TABLENAME
pivot
(
sum(Points) for Name in ('+@COLUMNS+')
) as pvt')