List Employee Birthdays and Anniversaries.

employee_birthday.sql

SELECT e.LastName, e.FirstName, 
       CASE WHEN c.EmpGCstF1 = 1 THEN 0 ELSE 1 END AS 'Birthday', e.BirthDate,
       CASE WHEN c.EmpGCstF2 = 1 THEN 0 ELSE 1 END AS 'Anniversary', e.HireDate
FROM Employee e
LEFT JOIN EmpCstFV c ON e.EmpUID = c.EmpUID AND c.CstID = 105 
WHERE e.CompanyID = 6
 AND e.TermDate IS NULL
ORDER BY e.LastName, e.FirstName