[MS SQL 2005]Ways to turn rows into columns

[szlamany]

From what I can see PIVOT does an AGGREGATE function - which I don't need.

And of course I have the issue of a "variable" number of columns for each gradebook.