Transponse result of SELECT (SQL Server)

Asked Oct 13 '16 at 15:19

Active Oct 13 '16 at 15:19

Viewed 40 times

I have a query :

SELECT ParentID, Type, Value FROM table1

and result :

| 1 | First  | Val1  |
| 1 | Second | Val2  |
| 2 | Second | Val3  |
| 3 | First  | Val4  |
| 2 | First  | Val5  |
| 3 | Second | Val6  |

So, how to modify this query to get result :

| ParentID | First | Second |
-----------------------------
| 1        | Val1  | Val2   |
| 2        | Val5  | Val3   |
| 3        | Val4  | Val6   |

asked Oct 13 '16 at 15:19

ksh.max

Will you have more than 2 values for `type`? – Lamak Oct 13 '16 at 15:20
Check for [**PIVOT**](https://technet.microsoft.com/es-es/library/ms177410(v=sql.105).aspx) – Juan Carlos Oropeza Oct 13 '16 at 15:21
Use Pivot function to solve this problem – Kushan Oct 13 '16 at 15:21
@Lamak yes, type have about 8 values. – ksh.max Oct 13 '16 at 15:27
@Kushan Can you show example for my case ? – ksh.max Oct 13 '16 at 15:28

0 Answers0