select c.calendarId, c.calendarName
from tbl_WRK_Calendars c
where c.linkType = 'EVT'
and c.linkId =
select eventDateId, eventDay, eventDate, coalesce(startTime,'7:00') startTime, coalesce(apptDurationMinutes,'15') apptDurationMinutes
from tbl_EVT_EventDates
where eventId =
order by eventDay