question

alter proc PICCMS_SP_GetExistingUsers                          
as                          
Select   U.UserID,(U.Firstname+' '+U.Lastname)as [Name],U.EmailID,U.Username,D.DomainCode ,UT.UserTypeName,U.Status  from Users U                     
inner join UserTypes UT on U.UserTypeID=UT.UserTypeID                    
inner join UserDomains UD on UD.UserID=U.UserID                    
inner join  Domains D on D.DomainID = UD.DomainID                    
where U.Status=1                    
order by U.Status Desc ,U.FirstName asc                    

This is my procedure

I want result like this

Username                Domains                    
================================                    
Christopher           AAA,BBB,CCC                    
KBR                   CCC,DDD                    

Like this i want result please give query

using UDF or While loop