case 分组汇总
select mo_no,mat_no,sto_type,
case when type='init' then
sum(qty1) as init1,sum(qty2) as init2,sum(qty3) as init3,
sum(0) as rec1,sum(0) as rec2,sum(0) as rec3,
sum(0) as iss1,sum(0) as iss2,sum(0) as iss3,
sum(0) as rtn1,sum(0) as rtn2,sum(0) as rtn3,
sum(0) as moto1,sum(0) as moto2,sum(0) as moto3,
sum(0) as moti1,sum(0) as moti2,sum(0) as moti3
when type='rec' then
sum(0) as init1,sum(0) as init2,sum(0) as init3,
sum(qty1) as rec1,sum(qty2) as rec2,sum(qty3) as rec3,
sum(0) as iss1,sum(0) as iss2,sum(0) as iss3,
sum(0) as rtn1,sum(0) as rtn2,sum(0) as rtn3,
sum(0) as moto1,sum(0) as moto2,sum(0) as moto3,
sum(0) as moti1,sum(0) as moti2,sum(0) as moti3
when type='iss' then
sum(0) as init1,sum(0) as init2,sum(0) as init3,
sum(0) as rec1,sum(0) as rec2,sum(0) as rec3,
sum(qty1) as iss1,sum(qty2) as iss2,sum(qty3) as iss3,
sum(0) as rtn1,sum(0) as rtn2,sum(0) as rtn3,
sum(0) as moto1,sum(0) as moto2,sum(0) as moto3,
sum(0) as moti1,sum(0) as moti2,sum(0) as moti3
when type='rtn' then
sum(0) as init1,sum(0) as init2,sum(0) as init3,
sum(0) as rec1,sum(0) as rec2,sum(0) as rec3,
sum(0) as iss1,sum(0) as iss2,sum(0) as iss3,
sum(qty1) as rtn1,sum(qty2) as rtn2,sum(qty3) as rtn3,
sum(0) as moto1,sum(0) as moto2,sum(0) as moto3,
sum(0) as moti1,sum(0) as moti2,sum(0) as moti3
when type='moto' then
sum(0) as init1,sum(0) as init2,sum(0) as init3,
sum(0) as rec1,sum(0) as rec2,sum(0) as rec3,
sum(0) as iss1,sum(0) as iss2,sum(0) as iss3,
sum(0) as rtn1,sum(0) as rtn2,sum(0) as rtn3,
sum(qty1) as moto1,sum(qty2) as moto2,sum(qty3) as moto3,
sum(0) as moti1,sum(0) as moti2,sum(0) as moti3
when type='moti' then
sum(0) as init1,sum(0) as init2,sum(0) as init3,
sum(0) as rec1,sum(0) as rec2,sum(0) as rec3,
sum(0) as iss1,sum(0) as iss2,sum(0) as iss3,
sum(0) as rtn1,sum(0) as rtn2,sum(0) as rtn3,
sum(0) as moto1,sum(0) as moto2,sum(0) as moto3,
sum(qty1) as moti1,sum(qty2) as moti2,sum(qty3) as moti3
end
into #balance
from #tmp
group by mo_no,mat_no,sto_type
语法错误,这样子不行
请教其它办法做分组汇总