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.
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.
1条答案
按热度按时间wfveoks01#
You want
APPLY
(i.e.CROSS APPLY
) in order to convert columns to row wise.