hi;
I am using sql server (msde) 2000 the report is already in excel manually
updated
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
EXT….
(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
thaks
