Displaying transactional data horizontally

By OrestesA ·
I am using sql server (msde) 2000 the report is already in excel manually
need help with a sql statement. I have a transactional data but I want to
represent it horizontally AND Pivoting doesn't work.
here is the example:

student(table) studentid, name .....
class(table) classid, semesterid subjectid grade(6th,7th,8th ext).....
subjects(table) subjectid subjectdesc credits
enrollment (table) classid studentid finalgrade(A,B,C...ext)

what I need is to generate the transcript in the following format

filtered by student.....

subjects 6th grade 7th grade 8th grade
I II crd I II crd I II crd

grammar A B .5 A B .5 C B .5
reading C B .5 C B .5 A B .5
(I = First semester and II = Second Semester)
pivoting doesn't work because it sums the grades instead of displaying the
actual grade......

if someone needs sample data and the database diagram i am gladly be able to provide it


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums