Hi,
You can try like this also....
SELECT T.deptno,
STUFF((SELECT ','+empname [text()] FROM urTable WHERE deptno=T.deptno FOR XML PATH('')),1,1,'') 'empname'
T.deptcount
FROM (SELECT deptno, COUNT(deptno) 'deptcount'
FROM urTable
GROUP BY deptno) T
Regards,
GVPrabu