In SQL Server how to Pivot for multiple columns

by

You gotta change the name of columns for next Pivot Statement.

Like 

SELECT
*
FROM
(
  SELECT 
   Branch,
   Category,
   Category+'1' As Category1,
   Category+'2' As Category2,
   Sales, 
   Stock, 
   Target
  FROM TblPivot
 ) AS P

 -- For Sales
 PIVOT
 (
   SUM(Sales) FOR Category IN ([Panel], [AC], [Ref])
 ) AS pv1

 -- For Stock
 PIVOT
 (
   SUM(Stock) FOR Category1 IN ([Panel1], [AC1], [Ref1])
 ) AS pv2

 -- For Target
 PIVOT
 (
   SUM(Target) FOR Category2 IN ([Panel2], [AC2], [Ref2])
 ) AS pv3
 GO

You are ready to go now….

You can use aggregate of pv3 to sum and group by the column you need.

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. SQL Server 2005 Pivot on Unknown Number of Columns
  9. TSQL Pivot without aggregate function
  10. Dynamically create columns sql
  11. TSQL PIVOT MULTIPLE COLUMNS
  12. Dynamic Pivot Columns in SQL Server
  13. SQL Server : dynamic pivot over 5 columns
  14. Pivot Table and Concatenate Columns
  15. Dynamic Pivot Table in SQL Server
  16. How to replace (null) values with 0 output in PIVOT
  17. Pivot data in T-SQL
  18. PIVOT query on Distinct records
  19. SQL Server PIVOT perhaps?
  20. Using PIVOT in SQL Server 2008
  21. How do I UPDATE from a SELECT in SQL Server?
  22. INNER JOIN vs LEFT JOIN performance in SQL Server
  23. Function vs. Stored Procedure in SQL Server
  24. Counting DISTINCT over multiple columns
  25. How to check if a stored procedure exists before creating it
  26. Why does SQL Server round off results of dividing two integers?
  27. SQL Server: should I use information_schema tables over sys tables?
  28. SQL Server Cumulative Sum by Group
  29. How to execute a stored procedure inside a select query
  30. SQL Inner Join On Null Values

Leave a Comment