• yes sorry, my mistake. if you don't mind you can try this

    select a.PersonID, a.Version, a.DEDate,

    case when b.PersonID is null then 0 else 1 end AS [Is ImProper]

    from PersonRecord a

    left join (

    select distinct a.PersonID

    from PersonRecord a

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

    ) b on a.PersonID = b.PersonID

    thanks