SQL Server How do I convert those columns to rows?

c86crjj0 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(145)

after convert, it should be

month   1 2    3 4 5 6 7 8 9 10 11 12   
planqty 0 0 6230 0 0 0 0 0 0  0  0  0    
actqty  0 0 2631 0 0 0 0 0 0  0  0  0

I will be so appreciated if you can help.

sql-server

来源：https://stackoverflow.com/questions/49375104/how-do-i-convert-those-columns-to-rows

1条答案

按热度按时间

wfveoks01#

You want APPLY (i.e. CROSS APPLY ) in order to convert columns to row wise.

select 
       qtynames as Month,
       max(case when dt = '01' then qty end) [01],
       max(case when dt = '02' then qty end) [02], 
       max(case when dt = '03' then qty end) [03],...
from table t cross apply (
    values ('month', dt, 'planqty', planqty), ('month', dt, 'actqty', actqty)
)a(mnames, dates, qtynames, qty)
group by qtynames

赞(0）回复(0）举报 2023-06-21

我来回答

SQL Server How do I convert those columns to rows?

1条答案

相关问题

热门标签

最新问答