摘要: 效果: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 阅读全文
posted @ 2012-09-21 14:40 ypq 阅读(320) 评论(0) 推荐(0) 编辑