Meeting Attend Dates Different
===========================================

This script helps to identify a very rare but annoying problem.

This problem is not readily visible,
but it manifests itself in another way 
when you see two Organization Member records for the same person in an organization.

We have seen this happen once before, but honestly don't know what can cause it.
We think it happens when you create a meeting with the incorrect time and then change that time.
But we know how to fix it and this is the script helps us to pinpoint the problem.

The fix by the way is to go to the offending meeting,
and change the meeting time to one minute later then change it back to the correct time.

The recommended name is ``MeetingAttendDatesDifferent``

Use the following code to Create the SQL Script.
See :doc:`../CreateSqlScript`.

.. code-block:: sql

    SELECT  a.MeetingId
           ,a.MeetingDate AttendDate
           ,m.MeetingDate
           ,o.OrganizationName
           ,p.PeopleId
           ,p.Name2
    FROM dbo.Meetings m
    JOIN dbo.Attend a ON a.MeetingId = m.MeetingId
    JOIN dbo.People p ON p.PeopleId = a.PeopleId
    JOIN dbo.Organizations o ON o.OrganizationId = m.OrganizationId
    WHERE a.MeetingDate <> m.MeetingDate