| > From PDL_ProcGroup t1(nolock) , PDL_ProcGroupDetail t2 (nolock)
Where t1.Id = t2.Id
Group By t1.Id, t1.Name
OPEN CheckWip
BEGIN
FETCH NEXT FROM CheckWip INTO @WipProcCode , @WipId
WHILE @@FETCH_STATUS = 0
BEGIN
IF Not Exists(Select * From #tmpStknwip Where Name = @WipProcCode and Id = @WipId )
Insert Into #tmpStknwip( Partnum, Revision , Qnty, Name , Id)
Select @CheckPartNum ,@CheckRevision , 0 ,@WipProcCode ,@WipId
FETCH NEXT FROM CheckWip INTO @WipProcCode , @WipId
END
END
CLOSE CheckWip
DEALLOCATE CheckWip
/* 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
