query for make columns into rows in ms sql server

Question

0.00/5 (No votes)

See more:

HTML

by using tables i am getting output as follows,

EmpName      Place          Dept    income     

   A        Chennai          IT      20
   B        Chennai          IT      30
   C        Chennai          IT      40
   D        Chennai          CSE     30
   A        Chennai          CSE     50
   B        Chennai          CSE     40
   C        Chennai          CSE     10
   D        Chennai          CSE     70
   A        Bangalore        IT      20
   B        Bangalore        IT      30
   C        Bangalore        IT      40
   D        Bangalore        IT      80
   A        Bangalore        EEE     20
   B        Bangalore        EEE     30
   C        Bangalore        EEE     40
   D        Bangalore        EEE     80



I need output as follows


Place           Dept                A      B     C     D

Chennai          IT                20     30    40    30
Chennai          CSE               50     40    10    70 
Bangalore        IT                20     30    40    80 
Bangalore        EEE               20     30    40    80 

can you please help me...ASAP...

Posted 24-May-13 1:58am

itsureshuk

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)

Aarti Meswania · Answer 1 · 2013-05-24T02:18:00

Solution 3

SQL

select place,dept,[A],[B],[C],[D] 
from TableName
pivot 
(
    sum(income) 
    for empname in ([A],[B],[C],[D])
)as pvttbl

Happy Coding!
:)

Posted 24-May-13 2:18am

Aarti Meswania

Arun Vasu · Answer 2 · 2013-05-24T02:41:00

Solution 4

SQL

SELECT PLACE, DEPT, A, B, C, D FROM
(
SELECT EMPNAME, PLACE, DEPT, INCOME FROM EMPLOYEE
)X
PIVOT (SUM(INCOME) FOR EMPNAME IN (A, B, C, D)) AS PVT

THIS IS YOUR QUERY FOR YOUR PROBLEM.

Posted 24-May-13 2:41am

Arun Vasu

Comments

itsureshuk 27-May-13 1:34am

Here A,B,C,D Employee Name more than 100 rows is there,,,,i cant directly pass