drop table [dbo].[X_tmpWeekProc]

Exec(''''select Partnum, Revision , DelDate=min(DelDate) ,UPP ''''+@s+'''' Into X_tmpWeekProc  from #Stknwip group by Partnum , Revision, UPP '''')

Select * Into #StknWipTotal  From X_tmpWeekProc

Drop Table X_tmpWeekProc

Select  t2.PartNum,t2.Revision, PQnty = Sum(t2.PQnty)

Into #InWarehouse

From PDL_PassBas t1(nolock),                     

        PDL_PassDtl t2(nolock),                     

        LotInfo t3(nolock)                     

Where t1.PaperNo = t2.PaperNo                     

    and  (t1.PaperDate >=  @BDateTime)

    and  (t1.PaperDate <= @EDateTime)

    and t2.AftProc >= ''''800''''                     

    and t2.LotNum = t3.LotNum              

    and t1.finished = 1            

    and t1.IsCancel = 0                      

Group By t2.PartNum,t2.Revision

------------------------------------增加仓位字段------------------------------

 Exec(''''ALTER TABLE  #StknWipTotal  add [InWarehouse]  int not NULL DEFAULT(0)'''') 

---------修改入库数----------

 Update t1  Set t1.InWarehouse = isnull(t2.PQnty,0) From #StknWipTotal t1 , #InWarehouse t2

Where t1.Partnum = t2.Partnum

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>