SELECT H_EMPLOYMENT.NAME_CH
FROM H_VACATION_ITEM INNER JOIN
H_EMPLOYMENT ON H_VACATION_ITEM.EMPLID = H_EMPLOYMENT.EMPLID
WHERE (CONVERT(VARCHAR(100), H_VACATION_ITEM.STARTDT, 23) = CONVERT(VARCHAR(100), GETDATE(), 23))
FROM H_VACATION_ITEM INNER JOIN
H_EMPLOYMENT ON H_VACATION_ITEM.EMPLID = H_EMPLOYMENT.EMPLID
WHERE (CONVERT(VARCHAR(100), H_VACATION_ITEM.STARTDT, 23) = CONVERT(VARCHAR(100), GETDATE(), 23))