Edward Boyle-478467 (10/8/2013)
Try thisDECLARE @PDFFileName VARCHAR(8000) =
(
SELECT STUFF(( SELECT ', ' + PDF_FileName + '.pdf' + char(13) + char(10)
FROM @PDFResult
ORDER BY 1 ASC FOR XML PATH(''),type).value('(./text())[1]','Varchar(8000)'),1,1,'')
)
Select @PDFFileName
hmmm, it didn't work still displays in my email as a long concatenated string " a.pdf,b.pdf,c.pdf "
I'm not too fussed about getting it working as it doesn't look too bad but now I'm just curious for a solution.