>>>Given a SQL2008 table structure:
>>>
>>>Id, ColumnId, RowId
>>>1 1 1
>>>2 1 2
>>>3 2 1
>>>4 2 2
>>>
>>>How do I convert it to:
>>>
>>>Row, Column1 Column2
>>> 1 1 3
>>> 2 2 4
>>>
>>>In case it's relevant the values are all GUIDS rather than ints and there will be more columns (and, obviously, rows)
>>>(Sorry about the spacing....)
>>
>>Sure, try:
>>
>>select RowID, [1] as Column1, [2] as Column2 from myTable PIVOT (Min(ID) for ColumnID in ([1],[2])) pvt
>>
>>from the top of my head - not tested.
>
>Min() won't work with uniqueidentiifer :-{
I'm thinking - simply cast uniqueidentifier to varchar(36) first.
If it's not broken, fix it until it is.
My Blog