Comparision Report of Students By Subjects

Question

1.00/5 (1 vote)

See more:

Hello Experts,

I have a tables for students records of subject wise. How can i get the record student wise and subject wise.

Ex:
Subject1 Subject2 ................N
Student1 Marks
Student2
.
.
.
N

XML

There Are Three Tables :

1 : Student : That have  Student Id and Student Name
2 : Subject : That Have Subject Id and Subject Name
3 : Student_Records : That have Student Id and Subject ID and Marks.


Now i want to generate the comparison record for all students and all subjects. Report will be in given format.

 <pre>
          Math         English     Art         Music   -----------------N
Student1   10             20        30           40
Student2   20            11         22           01
Student3   3             4           6            7
-
-
-
-
N</pre>

Thanks

Posted 22-Jan-12 21:34pm

Anubhava Dimri

Updated 23-Jan-12 4:51am

fjdiewornncalwe

v2

Add a Solution

Comments

OriginalGriff 23-Jan-12 3:53am

Sorry, but that doesn't make much sense - your example seems to have two different forms of data in the same table.
Please try to explain your table (or tables) structure a little more clearly.
Use the "Improve question" widget to edit your question and provide better information.

[no name] 23-Jan-12 3:58am

Yes You can say it we have two masters 1: Student 2 : Subject
And we are storing data in Students_Records table.

The Students and Subjects are dynamic that we can delete or add new.

Than How can we generate the record to analysis the Performance report according to all subjects.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2012-01-22T21:50:00

I think this will help you

SQL

DECLARE @StudentInfo AS TABLE
(
 Student NVARCHAR(50),
 Subject1 BIGINT ,
 Subject2 BIGINT ,
 Subject3 BIGINT ,
 Subject4 BIGINT 
)


INSERT INTO @StudentInfo 
SELECT 'Student1',54,42,50,62
Union
SELECT 'Student2',38,40,45,78



SELECT Student, Subject, Marks
FROM 
   (SELECT Student, Subject1, Subject2, Subject3, Subject4
   FROM @StudentInfo) p
UNPIVOT
   (Marks FOR Subject IN 
      (Subject1, Subject2, Subject3, Subject4)
)AS unpvt;