使用groupby和sum咋没有求和，AsnewWeight是想求一个月的重量求和，咋也显示为空

//也可以原纪录和汇总值多重组合，加载所有记录，每条记录都有汇总字段值，没有主键id，只能多条件匹配了
select 
convert(char(10),a.OperateDt,120) as OperateDt,
a.FurnaceNoVch,
a.SiliconLenthVch,
a.CateNameVch,
a.size,
a.WeightDbl1,
a.WeightDbl2,
(case a.WeightDbl1 when null then 0 else a.WeightDbl1 end)+(case a.WeightDbl2 when null then 0 else a.WeightDbl2 end) AsnewWeightDbl,
b.newWeightDbl1,
b.newWeightDbl2, 
a.FurnaceNoVch2,
a.FallDownName,
a.MasterNameVch,
a.MasterCodeVch 
from View_YRemoveRecord a

left join
(select convert(char(10),OperateDt,120) as OperateDt,
FurnaceNoVch,
SiliconLenthVch,
CateNameVch,
size,
sum(case WeightDbl1 when null then 0 else WeightDbl1 end) as newWeightDbl1,
sum(case WeightDbl2 when null then 0 else WeightDbl2 end) as newWeightDbl2, 
FurnaceNoVch2,
FallDownName,
MasterNameVch,
MasterCodeVch 
from View_YRemoveRecord 
where 1=1 
group by 
convert(char(10),OperateDt,120),
FurnaceNoVch,
SiliconLenthVch,
CateNameVch,
size,
FurnaceNoVch2,
FallDownName,
MasterNameVch,
MasterCodeVch)b

on convert(char(10),a.OperateDt,120)=b.OperateDt
and a.FurnaceNoVch=b.FurnaceNoVch
and a.SiliconLenthVch=b.SiliconLenthVch
and a.CateNameVch=b.CateNameVch
and a.size=b.size
and a.FurnaceNoVch2=b.FurnaceNoVch2
and a.FallDownName=b.FallDownName
and a.MasterNameVch=b.MasterNameVch
and a.MasterCodeVch=b.MasterCodeVch