convert rows into column in sql server

Priyanka Kumari

7y972

I have a table contaning subject marks of different class in this format.

Id Subject ProjMks ProjStatus TheoryMks TheoryStatus

1 Engish 18 p 40 p

1 Math 18 p 62 p

Now i want to display in following format :

Id EnglishProjectMks EnglishProjectSts EnglishTheoryMks EnglishTheorySts

1 18 p 40 p

MathsProjectMks MathsProjectSts MathsTheoryMks MathsTheorySts

18 p 62 p

Plz suggest me some query by which i can achieve this.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa7y ago
Accepted answer
Hello priyanaka

select Firstname, Amount, PostalCode, LastName, AccountNumber
from
(
select value, columnname
from yourtable
) d
pivot
(
max(value)
for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber)
) piv;
Or check these Links

https://stackoverflow.com/questions/15745042/efficiently-convert-rows-to-columns-in-sql-server

https://www.encodedna.com/sqlserver/pivot/convert-rows-into-columns-using-sqlserver-pivot.htm
Sourav Mukherjee7y ago
It is just like the matrix in maths. Do search on Pivots.
Gowtham Ramar7y ago
Do you know About Pivot Concept in sql,Refer the below url.

https://stackoverflow.com/questions/10428993/understanding-pivot-function-in-t-sql