SQL 以日期动态更新维护的数据,一周排程时间日期设计

               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]  ...  下一页 >> 

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18