Simple T-SQL statement to create a list of lookup values

-- Declare & initialize the CommaList variable.
DECLARE @CommaList VARCHAR(max)
SET @CommaList = ''	-- this must be initialized to an empty string. 

-- This select does the work
SELECT @CommaList = coalesce(@CommaList,'') + coalesce(StatusDesc,'') + ',' FROM ListTable

-- Remove the trailing ', ' characters.
SET @CommaList = SUBSTRING(@CommaList, 1, LEN(@CommaList)-1)

-- output our comma separated string.
print @CommaList