摘要:
效果:SizeBatchNoSizingDyeBatchsSZ1281656B2081036/B2081037/B20810421WITHSizingJob(SizeBatchNo,BatchNo)2AS(SELECTb.SizeBatchNo,3b.BatchNo4FROMWVMDB.dbo.wvSizingBatchInfoaWITH(NOLOCK)5LEFTJOINydmdb.dbo.ydbeambatchno_sizingbWITH(NOLOCK)ONa.Sizing_Batch_NO=b.SizeBatchNo6WHEREa.End_TimeISNULL7)8SELECTSizeBa 阅读全文