Hi everyone can someone pls help me with my data. I have an sql table(Test) in this form
Student_No Grade_code Test_N0 Mark
20427103 DS302 1 60
20427103 DS302 2 65
20427103 DS302 3 60
20427103 DS302 4 70
20427103 DS302 15 69

and

my stored procedure
Select * from Test
when i display it i want it to be in this format

Student_No Grade_code test_1 test_2 test_3 test_4 test_5
60 65 60 70 69


i tried to edit the table but my lecture said i can't but the display our marks like this and she also said that it depends on how u display it

PLEASE GUY CAN SOMEONE HELP ME AND ALLOW ME TO THANK YOU IN ADDVANCE (THANKS)

show some effort
you are wanting us to help with a stored procedure of this????

Select * from Test

Try this by creating temporary tables and display their contents.