pivot-without-aggregate

SQL Transpose Rows as Columns

August 7, 2023 by Tarik

Use: SELECT r.user_id, MAX(CASE WHEN r.question_id = 1 THEN r.body ELSE NULL END) AS “Do you like apples?”, MAX(CASE WHEN r.question_id = 2 THEN r.body ELSE NULL END) AS “Do you like oranges?”, MAX(CASE WHEN r.question_id = 3 THEN r.body ELSE NULL END) AS “Do you like carrots?” FROM RESPONSES r JOIN QUESTIONS q ON … Read more

TSQL Pivot without aggregate function

October 26, 2022 by Tarik

yes, but why !!?? Select CustomerID, Min(Case DBColumnName When ‘FirstName’ Then Data End) FirstName, Min(Case DBColumnName When ‘MiddleName’ Then Data End) MiddleName, Min(Case DBColumnName When ‘LastName’ Then Data End) LastName, Min(Case DBColumnName When ‘Date’ Then Data End) Date From table Group By CustomerId