I have a table that stores student grades:
A student could be given multiple grades for the same course throughout the year with the TermCode being the key.
I'd like to have a SQL statement that pivots this table and returns the data horizontally like a gradebook view:
123435 AlgebraI Mr. Smith A B+ B A-
123435 History Mr. Jones C C+ B- B
The list of possible TermCodes is known so that doesn't need to be dynamic and I do only need to return the four columns of potential term grades.