Re: Pivot Table Rows into Columns stored procedure

[Devart Team]

Try this one -

INSERT INTO t2
SELECT
  Product,
  SUM(CASE WHEN Measures = 'dollar_Sales' THEN value END) AS Dollar_Sales,
  SUM(CASE WHEN Measures = 'avg_sales' THEN value END) AS Avg_sales,
  SUM(CASE WHEN Measures = 'Base_Price' THEN value END) AS Base_Price
FROM
  T1
GROUP BY
  Product;

SELECT * FROM t2;
+----------+--------------+-----------+------------+
| Product  | Dollar_Sales | Avg_Sales | Base_Price |
+----------+--------------+-----------+------------+
| product1 |           15 |        20 |          2 |
| product2 |           25 |      NULL |       NULL |
+----------+--------------+-----------+------------+

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/