0

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)

3
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by stema08
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.