PIVOT is the strange magic to rotate a table in T-SQL.

I don't understand it yet. It will put the ids for rows as columns on a new in-memory table.