with Employee(employee_id, birthday) as
(
    select 1 as employee_id, dateadd(day, (abs(CHECKSUM(newid())) % 3650) * -1, getdate()) as birthday
    union all
    select Employee.employee_id + 1, dateadd(day, (abs(CHECKSUM(newid())) % 3650) * -1, getdate())
    from Employee where Employee.employee_id < 10
)
select employee_id, CONVERT( varchar(10), birthday, 104) AS birthday
     ,  DATEDIFF(yy, birthday, getdate()) - CASE WHEN MONTH(birthday) > MONTH(GETDATE()) OR 
                (MONTH(birthday) = MONTH(GETDATE()) AND DAY(birthday) > DAY(GETDATE())) THEN 1 ELSE 0 END from  Employee