1 WITH SizingJob ( SizeBatchNo, BatchNo )
2 AS ( SELECT b.SizeBatchNo ,
3 b.BatchNo
4 FROM WVMDB.dbo.wvSizingBatchInfo a WITH ( NOLOCK )
5 LEFT JOIN ydmdb.dbo.ydbeambatchno_sizing b WITH ( NOLOCK ) ON a.Sizing_Batch_NO = b.SizeBatchNo
6 WHERE a.End_Time IS NULL
7 )
8 SELECT SizeBatchNo ,
9 CASE WHEN LEN(SizingDyeBatchs) > 0
10 THEN STUFF(SizingDyeBatchs, LEN(SizingDyeBatchs), 1, '')
11 ELSE ''
12 END AS SizingDyeBatchs
13 FROM ( SELECT DISTINCT
14 SizeBatchNo
15 FROM SizingJob
16 ) a
17 CROSS APPLY ( SELECT SizingDyeBatchs = ( SELECT
18 BatchNo + '/'
19 FROM SizingJob
20 WHERE SizeBatchNo = A.SizeBatchNo
21 FOR XML PATH('') ,
22 TYPE
23 ).value('/', 'nvarchar(max)')
24
1 WITH SizingJob ( SizeBatchNo, BatchNo )
2 AS ( SELECT b.SizeBatchNo ,
3 b.BatchNo
4 FROM WVMDB.dbo.wvSizingBatchInfo a WITH ( NOLOCK )
5 LEFT JOIN ydmdb.dbo.ydbeambatchno_sizing b WITH ( NOLOCK ) ON a.Sizing_Batch_NO = b.SizeBatchNo
6 WHERE a.End_Time IS NULL
7 )
8 SELECT SizeBatchNo ,
9 CASE WHEN LEN(SizingDyeBatchs) > 0
10 THEN STUFF(SizingDyeBatchs, LEN(SizingDyeBatchs), 1, '')
11 ELSE ''
12 END AS SizingDyeBatchs
13 FROM ( SELECT DISTINCT
14 SizeBatchNo
15 FROM SizingJob
16 ) a
17 CROSS APPLY ( SELECT SizingDyeBatchs = ( SELECT
18 BatchNo + '/'
19 FROM SizingJob
20 WHERE SizeBatchNo = A.SizeBatchNo
21 FOR XML PATH('') ,
22 TYPE
23 ).value('/', 'nvarchar(max)')
24 ) b
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。