I do not fully understand what is going on in the query 

SELECT T.*

FROM @t T

    JOIN (

            SELECT T1.PersonID, MAX(T1.Added) AS Added

            FROM @t T1

            GROUP BY T1.PersonID

        ) D

        ON T.PersonID = D.PersonID

            AND T.Added =...