mardi 4 août 2015

Sql Server Pivoting

Trying to convert the row value to column (PIVOT) of the given table.

S.No          ID    Column2 Column3
1              1    1       Firstname
2              1    2       MiddleName
3              1    14      ContactNumber
4              2    1       Firstname
5              2    14      ContactNumber
6              3    14      ContactNumber
7              3    2       MiddleName

I want like below for ID 1

Clumn2  1           2           14
Column3 FirstName   MiddleName  LastName

please help me to solve it. Thanks

Aucun commentaire:

Enregistrer un commentaire