How to create Comma Separate Values List from Table in SQL Server

Comma Separate Values List 

Before going to below tutorial Download adventureworks database for sql server 2008 r2.

Below query shows, how to create comma separated list using COALESCE keyword.

declare @_MonthDay varchar(max)

Select @_MonthDay=COALESCE(@_MonthDay+']'+',[' , '[') + 
datename(mm,HireDate)+ ' '+cast(day(HireDate) as varchar) 
from [AdventureWorks2008R2].[HumanResources].[Employee] 
WHERE HireDate BETWEEN --@fromDate AND @toDate 
'2003-01-15' and '2003-01-20'
Group by 
 --year(HireDate),
 month(HireDate),
 day(hiredate),
 datename(mm,HireDate)
set @_MonthDay =@_MonthDay+']'
select @_MonthDay

Output:

How to create Comma Separate Values List from Table in SQL Server