Concatenate multiple rows into one column

create table Employee(

EmployeeID int identity(1,1),

EmpName varchar(200)

create table EmpProjects

(

EmpProjectID int identity(1,1),

EmployeeID int,

ProjName varchar(50)

insert into Employee values ('ram')

insert into Employee values ('reddy')

insert into EmpProjects values (1,'a')

insert into EmpProjects values (1,'b')

insert into EmpProjects values (2,'c')

insert into EmpProjects values  (2,'d')

select distinct EmpName ,(

select ProjName + ','

from EmpProjects EP

where EP.EmployeeID = E.EmployeeId

for xml path('')) as Projects

from Employee E

)
)