SQL Server: Examples of PIVOTing String data

by

Remember that the MAX aggregate function will work on text as well as numbers. This query will only require the table to be scanned once.

SELECT Action,
       MAX( CASE data WHEN 'View' THEN data ELSE '' END ) ViewCol, 
       MAX( CASE data WHEN 'Edit' THEN data ELSE '' END ) EditCol
 FROM t
 GROUP BY Action

More Related Contents:

  1. Understanding PIVOT function in T-SQL
  2. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  3. Pivot multiple columns based on one column in SQL Server
  4. SQL Server dynamic PIVOT query?
  5. When should I use semicolons in SQL Server?
  6. How to get Time from DateTime format in SQL?
  7. Parse JSON in TSQL
  8. Get size of all tables in database
  9. Fuzzy matching using T-SQL
  10. Replace duplicate spaces with a single space in T-SQL
  11. SQL Server Pivot Table with multiple column aggregates
  12. SQL Server: Isolation level leaks across pooled connections
  13. How do I use the CONCAT function in SQL Server 2008 R2?
  14. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  15. How do I exclude Weekend days in a SQL Server query?
  16. EXEC sp_executesql with multiple parameters
  17. SQL Server – Dynamic PIVOT Table – SQL Injection
  18. Can you call a webservice from TSQL code?
  19. How to add custom attributes to SQL connection string?
  20. SQL Server 2008 Vertical data to Horizontal
  21. Using PIVOT in SQL Server 2008
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. Compute MD5 hash of a UTF8 string
  25. LPAD in SQL Server 2008
  26. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  27. How do I remove non-breaking spaces from a column in SQL server?
  28. SQL SERVER – Understanding how MIN(text) works
  29. @@ERROR and/or TRY – CATCH
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment