<NONE> to BC
stuff((Select ' '+ nt.TextLine From [table1] FOR xml path('')),1,1,'')
STUFF((SELECT ' ' + TextLine FROM [table1] FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, '')
STRING_AGG
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)