Tuesday, 28 January 2020

SQL Get Multi Values in a Single Column

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), '' 
)

No comments:

SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...