UNPIVOT的應用

UNPIVOT的應用

select distinct NO,YEAR,MONTH,budgetversion,ISNULL(Sales,0) AS Sales,
…
getImport_History where YEAR=YEAR(GETDATE())

結果集
select *
from (結果集)A
UNPIVOT(
Budget_Amount（要取值） for attribute（要取字段） in(
[Sales]
…
,Trade
)
) as upv