--用法如圖 已, 分割 ''內存放數據 
  select    STUFF((SELECT ',' + '"' + ISNULL(mtl_no,'') + '"'         
          FROM SL_LOT_MTL_CHG_SUM_ITEM WITH(NOLOCK) WHERE doccode  = '1513000003' FOR XML PATH('')),1,1,'')        



          select *from SL_LOT_MTL_CHG_SUM_ITEM WHERE doccode  = '1513000003'
        

--用法如圖 已, 分割 ''內存放數據   
select refCodeitem,    STUFF((SELECT ',' + '"' + ISNULL(ItemType,'') + '"'         
          FROM imatdocitem  a WHERE c.refCodeitem=a.refCodeitem and DocCode='SR00013214'
         
          FOR XML PATH('')),1,1,''
           
          )    as nc    
        from imatdocitem c   where  c.DocCode='SR00013214'

        group by c.refCodeitem