try
declare @table table
(
NAME varchar(50),
SALARY int,
MONTH varchar(250)
)
insert into @table(NAME,SALARY,MONTH)values( 'aa',2000,'Jan')
insert into @table(NAME,SALARY,MONTH)values( 'aa',3000,'Feb')
insert into @table(NAME,SALARY,MONTH)values( 'bb',1000,'Mar')
insert into @table(NAME,SALARY,MONTH)values( 'bb',3000,'Apr')
insert into @table(NAME,SALARY,MONTH)values( 'bb',2500,'Jun')
SELECT Name, Salary = sum(salary), Month =
STUFF((SELECT ', ' + MONTH
FROM @table b
WHERE b.NAME = a.NAME
FOR XML PATH('')), 1, 2, '')
FROM @table a
GROUP BY NAME