I have a table called markregister. It has data something like
StudentId | PaperID | Marks
1 | 1 |10
1 | 2 |43
1 | 3 |36
The task is to show this data in a spreadsheet with 'Paper Name ' With that Paper Id as columns with corresponding marks in that subjects. Like
Student Name | Paper1 | Paper2 | Paper3
Henry | 10 | 43 | 36
How Can I Achieve This using sql (Server 2000)?. Thank You