T-SQL - how to swap rows and columns
15,978
Solution 1
SELECT a.ID, a.Value AS [Response], b.Value AS [Count]
FROM your_table AS a
INNER JOIN your_table AS b
ON a.ID = b.ID
WHERE a.Name = 'Response'
AND b.Name = 'Count'
Solution 2
this was always such a chore pre sql server 2005.
now i use PIVOT/UNPIVOT
Author by
Ash Machine
Updated on July 28, 2022Comments
-
Ash Machine almost 2 years
I have a resultset structure like this
ID Value Name 1 Oranges Reponse 1 42 Count 2 Apples Reponse 2 65 Count 3 Figs Reponse 3 74 Count
and I want to get to this:
ID Response Count 1 Oranges 42 2 Apples 65 3 Figs 74
using SQL. Is there a way to do this? thanks!