Create table #temp(name varchar(50),phone int,email varchar(max),amount money, skillName varchar(10));
insert into #temp values('jaydeep',444444,'jay@gmail.com',34,'mvc'),
('jaydeep',444444,'jay@gmail.com',34,'jquery'),
('jaydeepshah',50,'jaydeepshah81@yahoo.com', 50, 'css'),
('jaydeepshah',50,'jaydeepshah81@yahoo.com', 50, 'sql');
SELECT DISTINCT name,phone,email,Amount,
STUFF((SELECT DISTINCT ', '+ SkillName
FROM #temp as t1
WHERE T1.Name =t2.Name
FOR XML PATH(''),TYPE
).value('.','NVARCHAR(MAX)') ,1,2,'')AS SkillName
FROM #temp t2;
------------------------------------------
name phone email Amount SkillName
------------------------------------------
jaydeep 444444 jay@gmail.com 34.00 jquery, mvc
jaydeepshah 50 jaydeepshah81@yahoo.com 50.00 css, sql
-------------------------------------------------------------------
;WITH X AS(
SELECT
PersonalDetails.name, PersonalDetails.phone,
PersonalDetails.email,EndUser.Amount,SkillMaster.SkillName
FROM PersonalDetails INNER JOIN EndUser
ON PersonalDetails.ClientID = EndUser.UserId
INNER JOIN Userskilldetail ON Userskilldetail.clientId = PersonalDetails.ClientID
INNER JOIN SkillMaster ON SkillMaster.SkillID = Userskilldetail.Skillid)
SELECT DISTINCT name,phone,email,Amount,
STUFF((SELECT DISTINCT ', '+SKL.SkillName
FROM X AS SKL WHERE SKL.Name=X.Name
FOR XML PATH(''),TYPE
).value('.','NVARCHAR(MAX)') ,1,2,'')AS SkillName
FROM X