mercredi 18 mai 2016

Select rows horizontally in SQL Server 2005

I have Employee SQL Table (SQL Sever 2005):

EmployeeID Field1 Field2
121212     MISC1  ABC
121212     MISC2  XYZ
121213     MISC1  AAA
121213     MISC2  BBB

I would like to display the result like:

EmployeeID MISC1 MISC2
121212     ABC   XYZ
121213     AAA   BBB

Please advise and thank you in advance for your help.

Aucun commentaire:

Enregistrer un commentaire