Multiple column pivot in sql server

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

can't receive data after success login ? (0)New
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
How white label Uber app clone can help you start a taxi business like Uber? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
Where can I found sample MVC projects to learn and improve skills (1)
Extract a value from HTML string (0)
Get only year part from date string in SQL server (0)
More ...