i want some result as column ..

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

i want some result as column ..

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2011-12-12 : 12:53:18

Hello

I have table like this with records,

st_code ExamType marks
1 1st Term 25
1 1st Term 20
1 1st Term 25
1 2nd Term 24
1 2nd Term 23

Now I want result as every different term as column like below

st_code 1StTermExam marks 2ndTermExam marks
1 1st Term 25 2nd Term 24
1 1st Term 20 2nd Term 23
1 1st Term 25

how can i get like this

Regards

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-13 : 00:37:50

[code]
SELECT st_code,
MAX(CASE WHEN EXamType='1st Term' THEN EXamType END) AS [1stTermExam],
MAX(CASE WHEN EXamType='1st Term' THEN Marks END) AS [1stTermMarks],
MAX(CASE WHEN EXamType='2nd Term' THEN EXamType END) AS [2ndTermExam],
MAX(CASE WHEN EXamType='2nd Term' THEN Marks END) AS [2ndTermMarks]
FROM (SELECT ROW_NUMBER() OVER (PARTITION BY st_code,ExamType ORDER BY st_code) AS Rn,*
FROM tablename
)t
GROUP BY st_code,Rn
[/code]

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources