SELECT
mdd.MD_DATE_DATEINTEGER AS MD_Date_SnapshotDate,
mfb.MD_Room_SurrogateKey,
mdt.MD_Time_HourOfDay24 * POWER(2, 16) AS MD_Time_SnapshotTime,
mfb.MD_BItem_SurrogateKey,
mfb.MD_Event_SurrogateKey,
mfb.MD_SType_SurrogateKey,
mfb.MD_Sect_SurrogateKey,
mfb.MD_Building_SurrogateKey,
mfb.MF_Booking_ExpectedAttendees
FROM
   MF_BOOKING mfb
   INNER JOIN dbo.MD_DATE mdd
   ON mfb.MD_DATE_EVENTSTARTDATE <= mdd.MD_DATE_DATEINTEGER
      AND mfb.MD_DATE_EVENTENDDATE >= mdd.MD_DATE_DATEINTEGER
      AND MD_DATE_SQLDATE >= DATEADD(yy, -1, GETDATE())
      AND MD_DATE_SQLDATE <= DATEADD(dd, 7, GETDATE())
   INNER JOIN dbo.MD_TIME mdt
   ON mdt.MD_TIME_SECOND = 0
      AND (MD_TIME_MINUTE % 15) = 0
      AND mdt.MD_TIME_TIMEINTEGER >
         CASE
            WHEN mfb.MD_DATE_EVENTSTARTDATE = mdd.MD_DATE_DATEINTEGER THEN mfb.MD_TIME_EVENTSTARTTIME
-- Any time is valid here if the event started on a previous day; any time here is after the start time
            WHEN mfb.MD_DATE_EVENTSTARTDATE < mdd.MD_DATE_DATEINTEGER THEN 0
            ELSE NULL
         END
      AND mdt.MD_TIME_TIMEINTEGER <
         CASE
            WHEN mfb.MD_DATE_EVENTENDDATE = mdd.MD_DATE_DATEINTEGER THEN mfb.MD_TIME_EVENTENDTIME
-- Any time is valid here if the event ends on a subsequent day; any time here is before the end time
            WHEN mfb.MD_DATE_EVENTENDDATE > mdd.MD_DATE_DATEINTEGER THEN 2147483647
            ELSE NULL
         END
WHERE
   RTRIM(MF_BOOKING_ISCANCELED) = 'No'
-- AND mfb.MF_Booking_SchedulingSystem = 'EMS'