150 - Changed Weeks.sql

SELECT
  CurrentTimetable.School,
  CurrentTimetable.Activity,
  CurrentTimetable.HostKey,
  CurrentTimetable.Day,
  CurrentTimetable.Start,
  CurrentTimetable.DurationInMinutes,
  CurrentTimetable.WeekPattern,
  CurrentTimetable.Locations,
  ArchivedTimetable.WeekPattern AS OldValue,
  CurrentTimetable.WeekPattern AS NewValue,
  0 AS Deleted,
  0 AS New,
  0 AS Days,
  0 AS [Time],
  1 AS Weeks,
  0 AS Duration,
  0 AS Room
FROM
  CurrentTimetable 
  INNER JOIN 
    ArchivedTimetable ON CurrentTimetable.HostKey = ArchivedTimetable.HostKey
WHERE
  CurrentTimetable.WeekPattern<>[ArchivedTimetable]![WeekPattern];