SQL
Insert Into #DATA
Select CONVERT(varchar(355),t1.FFullName),
t1.FNumber,'','','',sum(isnull(v1.FOrderQty,0)), sum(isnull(v1.FCommitQty,0)),
sum(isnull(v1.FOrderQty,0))-sum(isnull(v1.FCommitQty,0)),
'',
Sum(ISNull(v1.FOrderQty,0)/(Case When ISNULL(t3.FCoefficient,0)=0 Then 1 Else t3.FCoefficient End )) ,
SUM(ISNull(v1.FCommitQty,0)/(Case When ISNULL(t3.FCoefficient,0)=0 Then 1 Else t3.FCoefficient End )),
SUM(ISNull(v1.FOrderQty- v1.FCommitQty,0)/(Case When ISNULL(t3.FCoefficient,0)=0 Then 1 Else t3.FCoefficient End )),2
From #DATA2 v1
Join t_ICItem t1 On v1.FItemID=t1.FItemID
Left Join t_Organization t2 On v1.FCustID=t2.FItemID
Left Join t_MeasureUnit t3 On t1.FSaleUnitID = t3.FMeasureUnitID
Where 1=1
GROUP BY t1.FFullName,t1.FNumber
Update t1 Set t1.FName=t2.FName,t1.FModel=t2.FModel, t1.FCUUnitName = t4.FName,t1.FUnitName=t3.FName,t1.Fstockqty=u1.fqty From
#Data t1,t_ICItem t2,t_MeasureUnit t3,t_MeasureUnit t4, ICInventory u1
Where t1.FNumber=t2.FNumber And t2.FUnitGroupID=t3.FUnitGroupID And t2.FSaleUnitID=t4.FMeasureUnitID And t3.FStandard=1
and u1.FItemID = t2.FItemID and u1.fqty<>0
汗,看了蒙,改列的地方在哪,Select CONVERT(varchar(355),t1.FFullName) as aaaa这里吗?怎么没变化?