Multiple column pivot in sql server

Posted by Kirthiga under Sql Server on 5/31/2018 | Points: 10 | Views : 444 | Status : [Member] | Replies : 0
How to arrive pivot table three columns side by side

Table
Prod Data Col A Col B Col C
A1 C1 5 2 2
B1 D1 4 3 4
A1 C1 6 4 6
A4 D1 5 3 3

Required Output
Prod D1 Col A D1 Col B D1 Col C D1 Col A D1 Col B D1 Col C
A1 11 6 8
A4 5 3 3
B1 4 3 4




Responses

(No response found.)

Login to post response