Member Avatar for ndodi

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
  • 76 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by stema08
Member Avatar for dickersonka

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

Select * from Test
Member Avatar for stema08

Try this by creating temporary tables and display their contents.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.