You can also use this one...

DECLARE @MyStatusList VARCHAR(1000)

SET @MyStatusList = ''

SELECT @MyStatusList = @MyStatusList + CASE WHEN @MyStatusList = '' THEN '' ELSE ', ' END + StatusDesc FROM MyStatus

SELECT...