change a table structure with SQL

[fliu]

Hello All,

I have a table with the following columns and structure:

app_num gradel date
1000 8 01/12/08
1000 9 03/23/08
1001 7 04/13/08
1001 10 10/12/08

I want to create a new table and input put data like this:
app_num grade1 date1 grade2 date2
1000 8 01/12/08 9 03/23/08
1001 7 04/13/08 10 10/12/08

Is it possible I can use SQlL to do the job?
Thanks

Frank

[rmiao]

Take look at pivot operator in books online.