/*
  Fix subtype on followups. Search for namelist res fails.
*/
UPDATE Followup SET SubType = 1 WHERE FollowupNumber IN (
  SELECT Followup.FollowupNumber
  FROM Followup WITH (NOLOCK)
  INNER JOIN ReservationFollowupXTab WITH (NOLOCK) ON ReservationFollowupXTab.FollowupNumber = Followup.FollowupNumber
    AND ReservationFollowupXTab.GuestNumber > 0
    AND SubType <> 1 
    AND Note LIKE 'Created %'
)
