| sp;
and t1.Layer=t2.Layer
and t2.IsInSC <> 1
and t1.Qnty>0
and t1.ProcCode not in(''''990'''',''''000'''')
and (( t1.PartNum >= @InBPartnum or @InBPartnum='''''''')
and (t1.PartNum <= @InEPartnum or @InEPartnum=''''''''))
and ((t1.Revision = @InBRevision or @InBRevision ='''''''')
and (t1.Revision = @InERevision or @InERevision =''''''''))
End
/*生成出货状态时间格式以及完整性生成*/
Declare @Partnum varchar(20) , @Revision varchar(5) , @Count int , @DateCount int
Declare @WeekDate datetime , @Com varchar(200)
Select @Com =''''A''''
DECLARE AddDateList INSENSITIVE CURSOR
FOR
Select Partnum, Revision From #WeekConfig
Group by Partnum, Revision
OPEN AddDateList
<< 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 