| Set @StrInt = Convert(varchar, @Daynum)
Exec ( '''' Insert Into #ToDate(Dateid, PartNum, Revision , TodayTime, Qnty ,DateStr, Todate)
Select t2.Dateid, Partnum=''''''''''''+@PartnumDate+'''''''''''', Revision=''''''''''''+@RevisionDate +'''''''''''',
t1.[Date'''' + @StrInt +''''] , Qnty = sum(Isnull(t2.[Qnty'''' + @StrInt +''''],0)),
DateStr ='''' +''''''''''''Qnty'''' + @StrInt +'''''''''''', t2.Todate
From Pdl_WeekProcedureDate t1(nolock) ,
Pdl_WeekProcedure t2(nolock)
Where t1.DateId = t2.DateId and t1.DateId='''''''' '''' + @CheckDate +''''''''''''
and t2.Partnum = '''''''''''' +@PartnumDate +'''''''''''' and t2.Revision = '''''''''''' +@RevisionDate+''''''''''''
Group By t1.[Date'''' + @StrInt +''''], t2.Dateid, t2.Todate '''' )
Set @DayNum = @DayNum + 1
End
FETCH NEXT FROM Cu_PartDate INTO @PartnumDate , @RevisionDate
END
END
CLOSE Cu_PartDate & << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> | 
