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(which is in excel) in the following format
filtered by student.....
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
sample data and database diagram attached