Employee Shift Check - Nested Cursor
So you want one row for each (employee,date), with shift details filled in for days on which the employee has a shift?

For this kind of problem use the "cross join, left join" pattern.  Start with a cross join that establishes the granularity of the result set, and then left join to the matching rows.  Something like:

SELECT 
    e.emp_id, 
    e.emp_number, 
    a.day_date,
    ea.area, 
    ea.shift_type,
    ea.start_time, 
    ea.finish_time 
FROM Employees e
CROSS JOIN AvailableDates a
LEFT JOIN EmployeeAvailability ea
   on a.AvailableDate = ea.day_date
   and e.emp_id = ea.emp_id