Select  Partnum, Revision , Qnty = sum(Qnty) ,

  DelDate , UPP , ProcCode = Name , Id

Into #Stknwip

 From  #tmpStknwip

Group By  Partnum, Revision , DelDate , UPP ,  Id , Name

Order By ID

/*判断完整性*/

 IF (( Not Exists( Select * from #WeekConfig ))  and  (Not Exists( Select * from #Stknwip )) )

   Begin

      Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)

         Select ''''not data'''' , ''''no'''' , 0 ,  ProcCode = Name , Id

          From PDL_ProcGroup

       Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate , Com)

         Select ''''not data'''' , ''''no'''' , 0 ,  @BDateTime, ''''A9''''

    End

  Else

  Begin

    IF Not Exists( Select * from #Stknwip )

       Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)

        Select ''''not data'''' , ''''no'''' , 0 ,  ProcCode = Name , Id

         From PDL_ProcGroup

     IF Not Exists ( Select * From  #WeekConfig  )

        Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate,  Com)

          Select Top 1  t1.Partnum, t1.Revision , Qnty = 0 , @BDateTime , ''''A9'''' 

           From Stknwip t1(nolock),   LotInfo t2(nolock)

             Where t1.LotNum=t2.LotNum                        &nb

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