Multiple column pivot in sql server

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

Get all materials of parent and its children in an array except for few (0)
Container in Media Query (0)
How to send keys to specified app with title? (1)
NullReferenceException when adding list (0)
How to run a VB.NET exe in the backend on Azure VM server? (0)
Null Reference Exception (0)
How do you parse the Subject Alternate Names from an X509Certificate2? (0)
Framework64\v4.0.30319\Config\web.config file is not well formed (0)
More ...