Select @Date1= Convert(datetime, Convert(varchar,Getdate(),101))

Select @Date2= @Date1+1 , @Date3 = @Date1+2, @Date4= @Date1+3,

        @Date5 = @Date1+4, @Date6 = @Date1+5 , @Date7 = @Date1+6

---------------修正更新为当天日期后向后推7天--------

IF Not Exists(Select * From Pdl_WeekProcedureDate

    Where Convert(datetime, Convert(varchar, DateId, 101)) =  Convert(datetime, Convert(varchar,@DateId,101)))

  Insert Into Pdl_WeekProcedureDate (DateId,Date1,Date2,Date3,Date4,Date5,Date6,Date7)

   Values(@DateId, @Date1, @Date2, @Date3, @Date4, @Date5, @Date6,@Date7)

----------将表 Pdl_WeekProcedure 里的数据换算成当天最新数据 " 对应程序维护接口 "—

Select @num = Isnull(DatedIFF(day, (Select Min(DateId) From Pdl_WeekProcedure ),

           (Select Max(DateId) From Pdl_WeekProcedureDate )),0) 

IF @num >0

Begin

  Set @Count = 1

  Set @num1 = @num

  Set @num2 = @num

  Set @num = 7 - @num

  Set @Str=''''''''

  While  @Count <= @num

   Begin

       Select @Str = @Str + '''' Qnty''''+Convert(varchar,@Count) + '''' = Qnty''''+Convert(varchar, @num1+1)+'''',''''

       Set @Count = @Count +1

       Set @num1 = @num1+1

   End

  While @num2 >0

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