• Not sure if this is what you are trying to do but how about:

    SELECT

    pr1.PersonID,pr1.Version,pr1.DEDate,

    CASE

    WHEN (pr1.DEDate < pr2.DEDate)

    THEN 1

    ELSE

    0

    END AS Improper

    FROM

    PersonRecord pr1

    LEFT JOIN PersonRecord pr2

    ON

    pr1.PersonID = pr2.PersonID

    AND

    pr1.Version = pr2.Version + 1