Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row

by

The posted answers work but are clumsy and slow. You can do what I call parallel aggregation:

SELECT
     ID,
     SUM(case when question_id = 1 then 1 else 0 end) as sum1,
     SUM(case when question_id = 2 then 1 else 0 end) as sum2,
     SUM(case when question_id = 3 then 1 else 0 end) as sum3
GROUP BY ID

This will do one pass over the table instead of three and is very short. It is not a complete walk-through but you can surely adapt the concept to your needs.

More Related Contents:

  1. SQl CASE Statement
  2. Levenshtein distance in T-SQL
  3. How to get sp_executesql result into a variable?
  4. How can I use optional parameters in a T-SQL stored procedure?
  5. Select query to remove non-numeric characters
  6. T-SQL Decimal Division Accuracy
  7. Selecting a Record With MAX Value
  8. T-SQL Pivot? Possibility of creating table columns from row values
  9. What is a “batch”, and why is GO used?
  10. TSQL divide by zero encountered despite no columns containing 0
  11. T-SQL loop over query results
  12. How to insert default values in SQL table?
  13. How to Round a Time in T-SQL
  14. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  15. t-sql get all dates between 2 dates [duplicate]
  16. Return a value if no rows are found in Microsoft tSQL
  17. How to pivot table with T-SQL?
  18. Using Aliases in Where Clause or an Alternative Option?
  19. Extract the first word of a string in a SQL Server query
  20. Testing for inequality in T-SQL
  21. Can I use the MERGE statement in SQL Server 2005?
  22. Replace a newline in TSQL
  23. T-SQL – function with default parameters
  24. How to use an Alias in a Calculation for Another Field
  25. Check if a varchar is a number (T-SQL)
  26. Using a cursor with dynamic SQL in a stored procedure
  27. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  28. String.Format like functionality in T-SQL?
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment