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