DECLARE @htmlText AS VARCHAR(MAX) = '<br/>'
SELECT STUFF
(
(
SELECT @htmlText + t.UserName
FROM Table t
FOR XML PATH(''), TYPE
)
.value('.[1]','nvarchar(max)'), 1, LEN(@htmlText), ''
)
SELECT STUFF
(
(
SELECT @htmlText + t.UserName
FROM Table t
FOR XML PATH(''), TYPE
)
.value('.[1]','nvarchar(max)'), 1, LEN(@htmlText), ''
)
No comments:
Post a Comment