Good Article but concatenating rows can be achieved with the help of following as well

DECLARE @FRUITS TABLE

(ID INT,

NAME VARCHAR(50)

)

INSERT INTO @FRUITS VALUES(101, 'BANANA')

INSERT INTO @FRUITS VALUES(102, 'ORANGE')

SELECT...