I have the following query which displays Employee Birthdays for the entire month and it displays null in the employee name field if there are no birthday. This works with Adventure works 2008 R2 Database
Now I implemented similar thing with my worker schedule db
I wanted to display the particular worker schedule for entire month,
I got it working but the only problem is that it doesn't show me records for days when employee is not scheduled.
I wanted to to show all dates for entire month except the scheduled date and name should be blank.
Can someone help,
I have attached both queries as attachment