Multiple column pivot in sql server

Posted by Kirthiga under Sql Server on 5/31/2018 | Points: 10 | Views : 846 | Status : [Member] | Replies : 0

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

(No response found.)

Latest Posts

Angular Material Datepicker is not working (0)New
Optimizing assemblies for performance failed. You can either exclude the failing assemblies (0)
Please help me on below interview questions (0)
Views folders are not getting published in .NET Core 3.x (0)
Points Not Display On Google map Although I Pushed Latitude And Longitude (0)
code first migration error in mvc (1)
How to List particular Records in sql server (1)
How to Update Dynamic File (0)
More ...