All Questions
Tagged with sql-server-localdb unpivot
1
question
1
vote
0
answers
63
views
Simple Unpivot - erroneous Column Conflict [duplicate]
Did I stumble across a reserved word here or something?
For, the following statement:
SELECT [Type]
FROM (SELECT 'Receive' AS [Rec], 'Transfer' AS [Trx]) [data]
UNPIVOT
(
[Orders] FOR [Type] IN ...