SQL - Pivot and Unpivot

Just for me to remember :)


Pivot:

SELECT API,[1],[2],[3],[4],[5],[6],[7],[8],[9],[10]
FROM (
             SELECT API, row_no, decLiquidBoe/24 AS boed
     FROM #tbl_Liquid_Prod_All
     )d
PIVOT
(SUM(boed) FOR row_no IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10])) AS pt


Unpivot:

 SELECT [API], [metric_date], [value]
 FROM #OH_Oil_Output
 UNPIVOT
 ([value] FOR metric_date IN ( [2020-01-01], [2020-02-01], [2020-03-01])) AS u