SQL query rows as columns [duplicate]

by

Test Data

DECLARE @Table TABLE(RecID INT,Name VARCHAR(20),Value VARCHAR(20))
INSERT INTO @Table VALUES
(1,'Color' ,'Red'),
(2,'Size'  ,'Small'),
(3,'Weight','20lbs'),
(4,'Shape' ,'Square')

Query

SELECT *
FROM
(SELECT Name,Value 
FROM @Table) T
PIVOT ( MAX(Value)
        FOR Name
        IN ([Color],[Size],[Weight],[Shape])
        )P

Result Set

╔═══════╦═══════╦════════╦════════╗
║ Color ║ Size  ║ Weight ║ Shape  ║
╠═══════╬═══════╬════════╬════════╣
║ Red   ║ Small ║ 20lbs  ║ Square ║
╚═══════╩═══════╩════════╩════════╝

More Related Contents:

  1. SQL Server dynamic PIVOT query?
  2. Efficiently convert rows to columns in sql server
  3. Convert Rows to columns using ‘Pivot’ in SQL Server
  4. Simple way to transpose columns and rows in SQL?
  5. T-SQL dynamic pivot
  6. SQL transpose full table
  7. SQL Server 2005 Pivot on Unknown Number of Columns
  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. SQL update query using joins
  22. SQL: IF clause within WHERE clause
  23. Where value in column containing comma delimited values
  24. How to use table variable in a dynamic sql statement?
  25. Search text in stored procedure in SQL Server
  26. Selecting first row per group
  27. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  28. How to find column names for all tables in all databases in SQL Server
  29. SQL update trigger only when column is modified
  30. Cumulative Total in MS Sql server [duplicate]

Leave a Comment