select eventId, eventName, surveyId, partnerId, partnerType from tbl_EVT_Events where eventId = select eventDateId, eventDay, eventDate, coalesce(startTime,'7:00') startTime, coalesce(apptDurationMinutes,'15') apptDurationMinutes from tbl_EVT_EventDates where eventId = order by eventDay select fslBuyingGroupId from tbl_CDR_Distributors where cdr_recordId = and ownerId = and fsl_tablecode = select calendarId, calendarName from tbl_WRK_calendars where linkId = and linkType = and ownerId = and ownerType =
Booth:
Date:
Time Company
select a.appointmentId, a.partnerId, a.partnerType, a.contactId, a.title, a.startTime, cdr.cdr_dstname, m.firstName, m.lastName, m.email from tbl_WRK_Appointments a inner join tbl_CDR_Distributors cdr on cdr.cdr_recordId = a.partnerId left outer join tbl_FSPro_members m on m.fspro_userid = a.contactId and m.orgId = a.partnerId and m.orgType = 'CDRD' where a.calendarId = and a.ownerId = and a.ownerType = and a.startTime = and a.partnerType = 'CDR'
#htmleditformat( _timeOfDay )# #htmleditformat( qmd_appointment.cdr_dstName )#
change remove choose