问SQL Server -逗号分隔的结果

EN

SELECT DISTINCT 
    DTL.DTL_ITEM_CRC DTL_ITEM_CRC, 
    PWK.PWK_PROMN_WEEK_KEY PWK_PROMN_WEEK_KEY, 
    HDR.HDR_VENDR_NBR HDR_VENDR_NBR, 
    HDR.HDR_VENDR_NAME HDR_VENDR_NAME 
FROM
    DBO.PROMWEEK PWK, DBO.BLTNHDR HDR, DBO.BLTNDET DTL, DBO.ITEMWHSE ITW
WHERE 
    DTL.DTL_BULTN_KEY = HDR.HDR_BULTN_KEY 
    AND HDR.HDR_PROMN_WEEK_KEY = PWK.PWK_PROMN_WEEK_KEY 
    AND HDR.HDR_BULTN_KEY = ITW.ITW_BULTN_KEY 
    AND DTL.DTL_ITEM_NBR = ITW.ITW_ITEM_NBR  
    AND DTL.DTL_ITEM_CRC IN ('2180198') 
    AND PWK.PWK_PROMN_WEEK_KEY IN ('31','32') 
    AND GETDATE() < PWK.PWK_START_DATE  
    AND DTL_ITEM_CRC != '0000000' 
    AND DTL.DTL_TBLD_CONUS_CNTRL > 0 
    AND DTL.DTL_TBLD_CONUS_EAST > 0 
    AND DTL.DTL_TBLD_CONUS_SOUTH > 0 
    AND DTL.DTL_TBLD_CONUS_WEST > 0
    AND DTL.DTL_SPECL_SELL > 0

DTL_ITEM_CRC    HDR_VENDR_NBR   HDR_VENDR_NAME  PROMO_WEEK
2180198 60531000    US COTTON LLC           31 
2180198 60531000    US COTTON LLC           32 

DTL_ITEM_CRC    HDR_VENDR_NBR   HDR_VENDR_NAME  PROMO_WEEK
2180198 60531000    US COTTON LLC           31 ,32

SELECT A.DTL_ITEM_CRC ,A.HDR_VENDR_NBR, A.HDR_VENDR_NAME,STUFF((SELECT distinct ','+ PWK1.PWK_PROMN_WEEK_KEY
                                                                  FROM DBO.PROMWEEK PWK1,DBO.BLTNHDR HDR1, DBO.BLTNDET DTL1, DBO.ITEMWHSE ITW1
                                                                  WHERE A.DTL_ITEM_CRC = DTL1.DTL_ITEM_CRC 
                                                                  AND A.HDR_VENDR_NBR = HDR1.HDR_VENDR_NBR 
                                                                  AND A.HDR_VENDR_NAME = HDR1.HDR_VENDR_NAME
                                                                  AND A.PWK_PROMN_WEEK_KEY = PWK1.pwk_promn_week_key
                                                                  GROUP BY PWK1.PWK_PROMN_WEEK_KEY
                                                                  FOR XML PATH(''), TYPE).value('.','VARCHAR(max)'), 1, 1, '') PROMO_WEEK
FROM  
(SELECT DISTINCT DTL.DTL_ITEM_CRC DTL_ITEM_CRC, PWK.PWK_PROMN_WEEK_KEY PWK_PROMN_WEEK_KEY, HDR.HDR_VENDR_NBR HDR_VENDR_NBR, HDR.HDR_VENDR_NAME HDR_VENDR_NAME 
FROM DBO.PROMWEEK PWK, DBO.BLTNHDR HDR, DBO.BLTNDET DTL, DBO.ITEMWHSE ITW
WHERE DTL.DTL_BULTN_KEY = HDR.HDR_BULTN_KEY AND HDR.HDR_PROMN_WEEK_KEY = PWK.PWK_PROMN_WEEK_KEY 
AND HDR.HDR_BULTN_KEY = ITW.ITW_BULTN_KEY AND DTL.DTL_ITEM_NBR = ITW.ITW_ITEM_NBR  
and DTL.DTL_ITEM_CRC in ('2180198') 
AND PWK.PWK_PROMN_WEEK_KEY in ('31','32') AND GETDATE() < PWK.PWK_START_DATE  AND DTL_ITEM_CRC != '0000000' 
AND DTL.DTL_TBLD_CONUS_CNTRL > 0 AND DTL.DTL_TBLD_CONUS_EAST > 0 AND DTL.DTL_TBLD_CONUS_SOUTH > 0 AND DTL.DTL_TBLD_CONUS_WEST > 0 AND DTL.DTL_SPECL_SELL > 0 ) A