SELECT LAST_NAME, FIRST_NAME, EMPLID, REPORTS_TO_MGR_NAME, REPORTS_TO_MGR_EMPLID
FROM _sde.v_HR
WHERE ( LAST_NAME =     'Adams'     AND FIRST_NAME =     'John '     )
 OR ( LAST_NAME =     'Jackson'     AND FIRST_NAME =     'Andrew'     )
 OR ( LAST_NAME =     'Lincoln'     AND FIRST_NAME =     'Abraham'     )
 OR ( LAST_NAME =     'Washington'     AND FIRST_NAME =     'George'     )
ORDER BY LAST_NAME, FIRST_NAME

DECLARE @EmployeesList TABLE
(
   last_name VARCHAR(100) NOT NULL,
   first_name VARCHAR(100) NOT NULL
);

INSERT INTO @EmployeesList(last_name, first_name)
   SELECT 'Adams', 'John ' UNION ALL
   SELECT 'Jackson', 'Andrew' UNION ALL
   SELECT 'Lincoln', 'Abraham' UNION ALL
   SELECT 'Washington', 'George';

SELECT EL.last_name, EL.first_name, HR.emplid, HR.reports_to_mgr_name, HR.reports_to_mgr_emplid
  FROM @EmployeesList AS EL
       LEFT OUTER JOIN
       _sde.v_HR AS HR
       ON HR.last_name = EL.last_name
          AND HR.first_name = EL.first_name
 ORDER BY ET.last_name, ET.first_name