Skip Ribbon Commands
Skip to main content
SharePoint
Use SHIFT+ENTER to open the menu (new window).
  
  
SQL
Reason
  
SELECT DISTINCT I.studentNumber, c.*
  FROM [AD12_v_CurrentHouseholdInfo] C
  JOIN [AD12_V_RG_Identity] I ON I.personId = C.personID
JOIN (
SELECT personID, Householdid, addressid
  FROM [AD12_v_CurrentHouseholdInfo]
  GROUP BY personID, householdId , addressid
  HAVING count(personID) > 1
) dups ON (dups.Householdid = c.householdId AND dups.personId = c.personid AND dups.addressId = c.addressId)

Lists personIDs for people that show up in more than one household.


Possible Causes:

 

  • ​Duplicate membership with no end dates
  • Duplicate addresses with no end dates.​