MS SQL UNPIVOT
\nSELECT product_id, store, price\nFROM (\n    SELECT product_id, store1, store2, store3\n    FROM Products\n) pvt\nUNPIVOT \n(\n    price FOR store IN (store1,
```\nSELECT product_id, store, price\nFROM (\n    SELECT product_id, store1, store2, store3\n    FROM Products\n) pvt\nUNPIVOT \n(\n    price FOR store IN (store1, store2, store3)\n) unpvt;\n```
[]