when 0         

          then ceiling(1 * t1.QNTY /(power(ISNULL(t3.LPiece,1),case t1.POP when 0 then 0 else 1 end)*           

                                                      power(ISNULL(t3.LLPiece,1) , case t1.POP when 2 then 1 else 0 end)))         

         when 1           

          then ceiling(1 * t1.QNTY * power(ISNULL(t3.LPiece,1),case t1.POP when 0 then 1 else 0 end) /           

                                                       power(ISNULL(t3.LLPiece,1) , case t1.POP when 2 then 1 else 0 end))               

         when 2         

          then (1 * t1.QNTY * power(ISNULL(t3.LPiece,1),case t1.POP when 0 then 1 else 0 end)*         

                                            power(ISNULL(t3.LLPiece,1) , case t1.POP when 2 then 0 else 1 end))               

     end),   DelDate = min(t4.ExpStkDate) ,  UPP = convert(varchar,t3.LPiece) +''''*''''+ convert(varchar, t3.LLPiece) ,

   t5.Id , t5.name

Into #tmpStknwip

from Stknwip t1(nolock),

         LotInfo t2(nolock),

         ProdBasic t3(nolock) ,

         OrderDetail t4(nolock) ,

         PDL_ProcGroup t5 (nolock) ,

         PDL_ProcGroupDetail t6 (nolock)

where t1.LotNum=t2.LotNum                                                                      

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>