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

        BEGIN                                 

        select  @StkDelDate = min(deldate), @StkUPP =min(upp) 

                   from #Stknwip

         Where Partnum = @StkPartnum and Revision = @StkRevision

        Update t1 Set  t1.DelDate = @StkDelDate , t1.UPP = @StkUPP From #Stknwip  t1 

        Where t1.Partnum = @StkPartnum  and t1.Revision = @StkRevision

                              and (isnull(t1.DelDate,''''01/01/1900'''')= ''''01/01/1900'''' or isnull(t1.UPP,''''-'''') = ''''-'''')

          FETCH NEXT FROM CU_StknWip INTO  @StkPartnum , @StkRevision   

         END                                         

                     END                                         

   CLOSE  CU_StknWip                                                                            

   DEALLOCATE  CU_StknWip              

Declare @s varchar(8000)

Set @s=''''''''

Select @s=@s+'''',[''''+rtrim(proccode)+''''] = max(case proccode when ''''''''''''+rtrim(proccode)+'''''''''''' then Qnty  else '''''''''''''''' end)''''

From #Stknwip  Group By proccode , Id  Order By Id

if exists (select * from dbo.sysobjects where id = object_id(N'

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

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

鄂公网安备 42011102001154号

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