Comma Separated Column Value In SQL Server

DECLARE @DATE VARCHAR(MAX) = '';

SELECT 
STUFF(
(
SELECT ', ' + CAST(COLUMNNAME AS VARCHAR(MAX))
FROM dbo.TABLENAME AS T WITH (NOLOCK)
WHERE 1 =1 
AND T.DATE = @DATE
FOR XML PATH('')
) , 1, 2, ''
);