SELECT E.Id, E.Name, E.CountryName, TD.Name, E.CountryName
       FROM EMPLOYEE AS E
OUTER APPLY GetDept(E.CountryName) TD