;With CTE
AS
(
Select distinct L.ProfileID as ProfileID,
B.Cust_ID as CustID,B.FirstName+' '+B.LastName as Name,
replace(convert(char(11),L.RegistrationDate,113),' ','-') as DOR,
E.FirstName+' '+E.LastName as OwnerOftheProfile,
E.EmpID as OwnerEmpID,E.BranchID as Branch,
replace(convert(char(11),B.EmpAssignedDate,113),' ','-') as AssignedDate,
EE.FirstName+' '+EE.LastName as ReviewedBy,EE.EmpID as ReviewedEmpID,
replace(convert(char(11),B.ProfileReviewedEmpDate,113),' ','-') as AssignedFromDate,
P.PageName 
from Cust_BasicInfo B join Cust_Login L on B.Cust_ID=L.Cust_ID 
join Cust_Details D on D.Cust_ID=L.Cust_ID left join Emp_Details E on E.EmpID=B.ProfileOwnerEmpID 
left join Emp_Details EE on EE.EmpID=B.ProfileReviewedEmpID  
left join Cust_DataStaging DS on DS.Cust_ID=B.Cust_ID 
join Mst_Section_Type MS on MS.SectionID=DS.SectionID  
join Mst_Page_Type P on P.PageID=MS.PageID
where L.IsReviewed=1 and DS.ReviewStatusID=0  
AND L.Cust_ID=2
)
SELECT c.*,
STUFF((SELECT ',' + PageName FROM CTE WHERE ProfileID = ProfileID
AND CustID = c.CustID
AND Name = c.Name
AND DOR = c.DOR
AND OwnerOftheProfile = c.OwnerOftheProfile
AND AssignedDate = c.AssignedDate
AND AssignedFromDate = c.AssignedFromDate
AND Name = c.Name 
AND Branch = c.Branch 
AND ReviewedEmpID = c.ReviewedEmpID 
FOR XML PATH('')),1,1,'') AS ScetionName
FROM (SELECT DISTINCT ProfileID,CustID,Name,Branch,ReviewedEmpID,AssignedDate,DOR,OwnerOftheProfile,AssignedFromDate FROM CTE)c

ProfileID	CustID	Name	Branch	ReviewedEmpID	AssignedDate	DOR	OwnerOftheProfile	AssignedFromDate	ScetionName
010000026	2	alla Kishore	7	3	13-Dec-2012	29-Nov-2012	Chaitanya Teja	01-Mar-2013	Education and Profession details,Photo details,Profile details,Education and Profession details,Profile details,Property details,Horoscope details,Partner preference details
010000123	12	fgfd gdfg	7	NULL	27-Feb-2013	06-Dec-2012	VBhaskaraReddy Kovvuri	NULL	Education and Profession details,Photo details,Profile details,Education and Profession details,Profile details,Property details,Horoscope details,Partner preference details

for 2 = Profile details,Education and Profession details,Photo details
for 3 = Relative details,My References details,Life style details,Spouce details,Property details