SELECT DISTINCT
        EmployeeId ,
        Date ,
        Employee ,
        STUFF(( SELECT  ' and ' + t2.Summary AS [text()]
                FROM    tblEmployee t2
                WHERE   t2.EmployeeId = t1.EmployeeId
              FOR
                XML PATH('')
              ), 1, 5, '') AS Summary
FROM    tblEmployee t1