Multiple rows into single column--T-sql

create table #details(sno int identity, empno int, pno varchar(3), Description varchar(30))insert into #details values(150,'P2','New Project')go
insert into #details values(150,'P1','S/W Project')go
insert into #details values(122,'P2','New Project')go
insert into #details values(122,'P1','Testing Project')go
insert into #details values(122,'P1','Existing Project')go
insert into #details values(124,'P1','Testing Project')go
insert into #details values(124,'P1','S/W Project')select * from #detailsgo
select empno,stuff((select ' ,' +pno+' '+ description from #details a where A.empno=b.empno for xml path('')),1,2,'')from #details b group by b.empno