/* Created by free online sql formatter */

CREATE PROCEDURE humanresources.usp_getemployees
                @lastname  VARCHAR(40),
                @firstname VARCHAR(20)
AS
  SELECT lastname,
         firstname,
         jobtitle,
         department
  FROM   humanresources.vemployeedepartment
  WHERE  firstname = @firstname
         AND lastname = @lastname;

GO