-
Query to do a pivot
I have a table with columns like this EmpID, LastName, FirstName. So in the table a record looks like this:
Code:
EmdID LastName FirstName
-----------------------------
1 Dent Arthur
What I need to do is take that row and pivot it like this:
Code:
EmdID 1
LastName Dent
FirstName Arthur
From what I have gathered I think I need to use a Union Select to select my fields one at a time and then join them together at the end. I am having problems with the syntax though and haven't got passed the Select Statement. How do I accomplish this?