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
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
版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。