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
...
原创
2020-10-30 15:15:18 ·
237 阅读 ·
0 评论