Multiple column pivot in sql server

Posted by Kirthiga under Sql Server on 5/31/2018 | Points: 10 | Views : 953 | 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

how to disable button in mvvm in wpf (0)
On .pub file download, it downloads as .ashx file (0)
Login Url mention needed ? (1)
How to implement Captcha code in Angular8 (1)
Ace 12.0 is not registered on local machine (0)
Can we have same port in single websites? (0)
Zipping of excel files using c# (1)Updated
How to install Redis cache in Windows (0)
More ...