convert rows into column in sql server

Nov 16 2018 1:48 AM

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.

Answers (3)