Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
May 23, 2012 12:49 PM|LINK
Thank you for your solution, it is very elegant... and would love to use it, however I am getting the following error when attempting to run this in SQL Server Management Studio.
I made some minor changes to account for the corrected table name (HANES_ProcessedContainers), and the name of the id (PC_ID) field, as follows:
;WITH mycte AS
(SELECT PC_ID,col, val from (SELECT * FROM Hanes_ProcessedContainers) src
unpivot (val for col in ([Slot1],[Slot2],[Slot3],[Slot4],[Slot5]))unpvt
SELECT PC_ID, [Slot1],[Slot2],[Slot3],[Slot4],[Slot5] FROM (select
PC_ID,col, val FROM mycte) src
PIVOT(max(val) FOR col IN ([Slot1],[Slot2],[Slot3],[Slot4],[Slot5])) pvt
I receive the following errors:
"Unable to parse query text"
Error Message: Line 1: Incorrect syntax near ';'.
Line 1: Incorrect Syntax near 'unpivot'.
Line 1: Incorrect Syntax near 'PIVOT'.
Your further assistance would be appreciated. Thanks!!