22,300
社区成员




-- 重建索引
dbcc dbreindex('Fact_Pmrelate','',90)
-- 更新统计信息
update statistics Fact_Pmrelate
-- 确认SQL2005该表索引情况是否与SQL2000该表一致.
-- 改为这样写法试一下..
Select f.Goodsid,r.RawId,
sum(round(PerWaste*r.Factor*(case when isnull(f.factor ,0)<=0 then 1 else 1/f.factor end), 9)) As PerWaste,
sum(round(case When p.Waste = 1 Then 0 Else p.PerWaste * r.Factor * p.Waste * (case when isnull(f.factor ,1)<=0 then 1 else 1/f.factor end)/(1 - p.Waste) End,5)) As Waste,
@userid define_by, @sysdate define_time, @userid modi_man, @sysdate modi_date
Into #temp_create_new_goods_cons
From Fact_Pmrelate (nolock) p
inner join Fact_Raw (nolock) r on p.Fmid=r.Fmid
inner join #temp_create_new_goods f on p.FPid = f.Fpid
inner join raw (nolock) t on r.RawId=t.RawId
where p.OrgNo=@OrgNo
Group By f.Goodsid,r.RawId