HOW TO COMBINE ROW DATA INTO A SINGLE COLUMN/VARIABLE

CREATE TABLE #TEMP

(

NAME VARCHAR(10),

ID INT

)

INSERT INTO #TEMP

SELECT 'I',1

UNION ALL SELECT ' LO',2

UNION ALL SELECT 'VE',3

UNION ALL SELECT ' Y',4

UNION ALL SELECT 'OU',5

UNION ALL SELECT ' A',6

UNION ALL SELECT 'LL',7

SELECT * FROM #TEMP

--NOW THE QUESTION IS : HOW TO COMBINE ROW DATA INTO A SINGLE COLUMN/VARIABLE ?

DECLARE @COMBINE VARCHAR(200)

SET @COMBINE=''

SELECT @COMBINE=@COMBINE + NAME FROM #TEMP

PRINT @COMBINE

--YOU GET “I LOVE YOU ALL” AS OUTPUT

Others