SQL Server 2005 Pivot on Unknown Number of Columns

by

I know you said no dynamic SQL, but I don’t see any way to do it in straight SQL.

If you check out my answers to similar problems at Pivot Table and Concatenate Columns and PIVOT in sql 2005

The dynamic SQL there is not vulnerable to injection, and there is no good reason to prohibit it. Another possibility (if the data is changing very infrequently) is to do code-generation – instead of dynamic SQL, the SQL is generated to a stored procedure on a regular basis.

More Related Contents:

  1. SQL query rows as columns [duplicate]
  2. SQL Server dynamic PIVOT query?
  3. Efficiently convert rows to columns in sql server
  4. Convert Rows to columns using ‘Pivot’ in SQL Server
  5. Simple way to transpose columns and rows in SQL?
  6. T-SQL dynamic pivot
  7. SQL transpose full table
  8. TSQL Pivot without aggregate function
  9. Dynamically create columns sql
  10. TSQL PIVOT MULTIPLE COLUMNS
  11. Dynamic Pivot Columns in SQL Server
  12. SQL Server : dynamic pivot over 5 columns
  13. Pivot Table and Concatenate Columns
  14. Dynamic Pivot Table in SQL Server
  15. How to replace (null) values with 0 output in PIVOT
  16. Pivot data in T-SQL
  17. PIVOT query on Distinct records
  18. SQL Server PIVOT perhaps?
  19. In SQL Server how to Pivot for multiple columns
  20. Using PIVOT in SQL Server 2008
  21. Making a dynamic pivot table but without using the fiddle
  22. How to return only the Date from a SQL Server DateTime datatype
  23. Convert Datetime column from UTC to local time in select statement
  24. Concat groups in SQL Server [duplicate]
  25. Pivoting rows into columns dynamically in Oracle
  26. varbinary to string on SQL Server
  27. Query comparing dates in SQL
  28. SQL Server silently truncates varchar’s in stored procedures
  29. How to do an inner join on row number in sql server
  30. SQL Server 2005 ROW_NUMBER() without ORDER BY

Leave a Comment