Display row to column in sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

Hello Friends ,

i have record like in my table

SchoolCode	Grade Type	Girls	Boys
ABC	1	5	12
ABC	2	7	14
ABC	3	12	5
ABC	4	14	3
ABC	5	22	1
ABC	6	15	2
ABC	7	18	7
ABC	8	19	9

And i want to get result like

SchoolCode Grade1Girls Grade1Boys Grade2Girls Grade2Boys...up to Grade8Girls Grade8Boys

So what can i do???

please help me

Posted 3-Dec-12 1:30am

Shingala Anil

Add a Solution

2 solutions

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)

Rai Pawan · Answer 1 · 2012-12-03T01:36:00

Solution 1

Shingala,

You need to check the pivoting/unpivoting in SQL server. Please check this http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

Regards
Pawan

Posted 3-Dec-12 1:36am

Rai Pawan

Comments

Shingala Anil 3-Dec-12 8:18am

No one help me i want display multiple row as column not a single row as column

**AmitGajjar** · Answer 2 · 2012-12-03T01:37:00

Solution 2

Hi,

You can use PIVOT SQL function to do this,

Here are some example links,

http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx[^]

http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx[^]

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

Best luck

Posted 3-Dec-12 1:37am

AmitGajjar

Comments

Shingala Anil 3-Dec-12 8:18am

No one help me i want display multiple row as column not a single row as column

AmitGajjar 3-Dec-12 8:20am

If PIVOT not work for you, then you can create one CURSOR and iterate through rows and generate temporary table and fill the data.

Shingala Anil 3-Dec-12 8:19am

i want to display Gradetype With Girls and Boys I Need 16 Column as Output 8 for Girls and 8 For Boys Bcoz Gradetype have 8 Values

Shingala Anil 3-Dec-12 8:22am

Ok let me try

AmitGajjar 3-Dec-12 8:23am

Although CURSOR logic will look complicated but it will work in your case.