converting rows into columns

Question

I have a table in sql server 2005 where there are 3 columns id ,question and answer.

the data is as below-

id  question  answer    
1   married    yes
1   name       John
2   married    No
2   name       Dave
3   married    yes
3   name       Rob

I'm expecting results like the one below-

ID  married  name
1   yes      John
2   no       Dave
3   yes      Rob

Thanks in advance

Thanks Juan Carlos for editing it.

Sachin25
– Sachin25

2016-07-20 22:20:35 +00:00
Commented Jul 20, 2016 at 22:20 — Sachin25
– Sachin25, Commented Jul 20, 2016 at 22:20

M.Ali · Accepted Answer · 2016-07-20 22:25:48Z

2

Select ID
      ,MAX(CASE WHEN question = 'married' THEN answer END) AS Married
      ,MAX(CASE WHEN question = 'name'    THEN answer END) AS Name
FROM TableName
GROUP BY ID

answered Jul 20, 2016 at 22:25

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

converting rows into columns

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related