How to concat one column of multiple rows (group by clause used in query)
A pivot will work for this

Test Data:

Declare @Test Table
(
 EMPID          Int
,PROJ_TYPE      NVarchar(4)
,HOURS          Int
,ST_DATE        Date
,ED_DATE        Date
);
Insert Into @Test
(EMPID, PROJ_TYPE, HOURS, ST_DATE, ED_DATE)
Values ('1', 'DEV','10','2013-1-1','2013-5-1')
        ,('1', 'DEV','34','2013-5-2','2013-8-1')
        ,('1', 'DEV','23','2013-8-2','2013-10-1')
        ,('1', 'TEST','12','2014-1-1','2014-3-1')
        ,('1', 'TEST','25','2014-3-2','2014-6-1')
        ,('2', 'DEV','7','2013-5-2','2013-8-1')
        ,('2', 'DEV','14','2013-8-2','2013-10-1')
        ,('2', 'TEST','12','2014-1-1','2014-3-1')
        ,('2', 'TEST','19','2014-3-2','2014-6-1')
        ,('3', 'DEV','34','2013-5-2','2013-8-1')
        ,('3', 'DEV','8','2013-8-2','2013-10-1')
        ,('3', 'TEST','12','2014-1-1','2014-3-1')
        ,('3', 'TEST','7','2014-3-2','2014-6-1')
        ,('3', 'DEV','23','2013-8-2','2013-10-1')
        ,('3', 'TEST','18','2014-1-1','2014-3-1')
        ,('4', 'TEST','25','2014-3-2','2014-6-1');


Query:

Select      EMPID
            ,IsNull(DEV,0) As DEV
            ,IsNull(TEST,0) As TEST
From        (
            Select      EMPID
                        ,PROJ_TYPE
                        ,HOURS
            From        @Test
            ) sq
    Pivot   (
            Sum(HOURS)
            For PROJ_TYPE In ([DEV],[TEST])
            ) piv;


SQL Fiddle: 
https://dbfiddle.uk/?rdbms=sqlserver_2017&amp;fiddle=6d9a0ceb9dbf13e8af351822733c4607