>>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 :-{