• Am I missing something ?

    select a.PersonID,a.Version, a.DEDate , 1 AS [Is ImProper]

    from PersonRecord a

    inner join PersonRecord b on a.PersonID = b.PersonID and a.Version>b.Version and a.DEDate<b.DEDate