2023-07-11から1日間の記事一覧
SELECT Year, Month, Half, Fiscal_Year, Quater, department, value FROM ( SELECT Year, Month, Half, Fiscal_Year, Quater, 制作1, 制作2, ..., 制作N FROM your_table ) AS source_table UNPIVOT ( value FOR department IN (制作1, 制作2, ..., 制…
SELECT Year, Month, Half, Fiscal_Year, Quater, department, value FROM ( SELECT Year, Month, Half, Fiscal_Year, Quater, 制作1, 制作2, ..., 制作N FROM your_table ) AS source_table UNPIVOT ( value FOR department IN (制作1, 制作2, ..., 制…