select d.FullDate,
  a.ApptDescription,
  a.ApptStartDate + a.ApptStartTime AS ApptStart,
  a.ApptEndDate + a.ApptEndTime AS ApptEnd
from DimDate AS d
left join Appointments AS a
  on d.FullDate = a.ApptStartDate
order by d.FullDate;