iscomar001
10/18/2016 - 4:05 PM

Concatenate Select

Concatenate Select

DECLARE @Names VARCHAR(8000) 
SELECT @Names = COALESCE(@Names + ', ', '') + Name
FROM People
WHERE Name IS NOT NULL