原列:
249
169
現在數據
249,169
SELECT STUFF((select ',' + CONVERT(VARCHAR(100),[STORE_ID]) FROM CARD_CAMPAIGN_STORE where FORM_ID = 5 FOR XML PATH('')),1,1,'')
原列:
249
169
現在數據
249,169
SELECT STUFF((select ',' + CONVERT(VARCHAR(100),[STORE_ID]) FROM CARD_CAMPAIGN_STORE where FORM_ID = 5 FOR XML PATH('')),1,1,'')