select row as column in sql server

DECLARE @strValues varchar(8000)
 SELECT @strValues = COALESCE(@strValues+',', '') + MainID
FROM
(
    SELECT   MainID
    FROM EndUser
) X
ORDER BY MainID


select @strValues