sql query to convert row into column

Question

0.00/5 (No votes)

See more:

i have a table with schema like below image

id     empcode      question      answer     date
1        011        ur name?      abcd         20/10/2013
2        011        ur lastname?  abcd         20/10/2013
3        011        ur number?    abcd         20/10/2013
4        011        ur email?     abcd         20/10/2013
5        011        ur name?      xyz          21/10/2013
6        011        ur lastname?  xyz          21/10/2013
7        011        ur number?    xyz          21/10/2013
8        011        ur email?     xyz          21/10/2013

i need select query table like

    date    empcode       ur name?     ur lastname?      ur number?  ur email?
 20/10/2013       011           abcd          abcd             abcd        abcd
21/10/2013        011            xyz           xyz             xyz        xyz

Posted 22-Nov-13 21:11pm

cyber_addicted

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

cyber_addicted · Answer 1 · 2013-11-22T22:55:00

SELECT *
FROM
(
SELECT [question_id], [date], [answer]
FROM dsr_ques_ans where empcode='EMP-820485-2'
) AS source
PIVOT
(
MAX([answer])
FOR [question_id] IN ([1], [2], [3],[4])
) as pvt;

SELECT date,
MAX(CASE WHEN question_id= '1' THEN answer ELSE NULL END) [1],
MAX(CASE WHEN question_id= '2' THEN answer ELSE NULL END) [2],
MAX(CASE WHEN question_id= '3' THEN answer ELSE NULL END) [3],
MAX(CASE WHEN question_id= '4' THEN answer ELSE NULL END) [4]
FROM dsr_ques_ans
GROUP BY date

got my solution

thatraja · Answer 2 · 2013-11-22T21:15:00

Solution 1

Use PIVOT - UNPIVOT

Using PIVOT and UNPIVOT[^]
Pivoting data in SQL Server[^](Alternate ways)

Posted 22-Nov-13 21:15pm

thatraja

Comments

[no name] 23-Nov-13 3:35am

yes it is but how can i implement this. i need exact solution

sql query to convert row into column

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

sql query to convert row into column

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us