Get comma separated column vaue in SQL

CREATE PROCEDURE [dbo].[EmailIds] AS Declare @Email VARCHAR(max) Select @Email = COALESCE(@Email + ', ', '') + email from usersnew Select @Email as Email