SQL query statement (convert data tables from vertical to horizontal)

 

My table structure:
ID (primary key) studentno courseno score
1 01 2001 99
2 01 2002 98
3 01 2003 97
4 02 2001 95
5 02 2002 94
6 02 2003 93
-----------------------------------------------
Query Result
Studentno 2001 2002 2003
01 99 98 97
02 95 94 93
Declare @ s varchar (8000)
Set @ s = @ s + ', [' + Cast (courseno as varchar) + '] = sum (Case courseno when''' + Cast (courseno as varchar) + '''then score end )'
From table
Group by courseno
Exec ('select studentno' + @ s + 'from table group by studentno ')

Reproduced csdn: http://topic.csdn.net/t/20040611/09/3082327.html