对以下语句如何优化:
能不能直接一条语句插入;
我看了更新占用太长的时间!
或者有更好的写好!
insert into @table(boxcode,matcode,basedigit,sizecode01,sizecode02,sizecode03,sizecode04,
sizecode05,sizecode06,sizecode07,sizecode08,sizecode09,sizecode10)
select b.boxcode,b.matcode,sum(isnull(b.basedigit,0)-isnull(xdbasedigit,0)) as basedigit,
sum(case when isnull(sizecode01,0) <> 0 then isnull(sizecode01,0)-isnull(sizecodexd01,0) else 0 end) sizecode01,
sum(case when isnull(sizecode02,0) <> 0 then isnull(sizecode02,0)-isnull(sizecodexd02,0) else 0 end) sizecode02,
sum(case when isnull(sizecode03,0) <> 0 then isnull(sizecode03,0)-isnull(sizecodexd03,0) else 0 end) sizecode03,
sum(case when isnull(sizecode04,0) <> 0 then isnull(sizecode04,0)-isnull(sizecodexd04,0) else 0 end) sizecode04,
sum(case when isnull(sizecode05,0) <> 0 then isnull(sizecode05,0)-isnull(sizecodexd05,0) else 0 end) sizecode05,
sum(case when isnull(sizecode06,0) <> 0 then isnull(sizecode06,0)-isnull(sizecodexd06,0) else 0 end) sizecode06,
sum(case when isnull(sizecode07,0) <> 0 then isnull(sizecode07,0)-isnull(sizecodexd07,0) else 0 end) sizecode07,
sum(case when isnull(sizecode08,0) <> 0 then isnull(sizecode08,0)-isnull(sizecodexd08,0) else 0 end) sizecode08,
sum(case when isnull(sizecode09,0) <> 0 then isnull(sizecode09,0)-isnull(sizecodexd09,0) else 0 end) sizecode09,