How to change rows to colums using view in sql 2008

Question

0.00/5 (No votes)

See more:

I have table A with this data
StudentID Subject Score
S001 Maths 40
S001 English 60
S002 Maths 66
S002 English 43
S003 Maths 78
S003 English 30

I want to create a view that will represent it in this form in sql server 2008
StudentID English Maths
S001 60 40
S002 43 66
S003 30 78

Can some one help me out?

Posted 23-Jan-13 20:37pm

wizy@2020

Add a Solution

Comments

Amol_B 24-Jan-13 5:24am

This can be achieved by using PIVOT

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)

Tharaka MTR · Accepted Answer · 2013-01-24T16:14:00

Solution 1

You can use PIVOT query,
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.100).aspx[^]

try your self and get back to us if you need any more help

Posted 24-Jan-13 16:14pm

Tharaka MTR