SELECT 
     PersonRecord.*,
     Improper.[IsImProper]
FROM PersonRecord
INNER JOIN(
	SELECT 
	     a.PersonID,
	     MAX(CASE 
	               WHEN a.Version < b.version and A.DEDate > B.DEDate 
	           THEN 1 
	           ELSE 0 
	           END) as IsImProper
	FROM PersonRecord A
	INNER JOIN PersonRecord B
	     ON A.PersonID = B.PersonID AND
	          A.Version = B.Version -1 
	GROUP BY A.PersonId
) AS Improper
     ON Improper.[PersonID] = PersonRecord.PersonID

SELECT PersonID, 1 as improper
FROM #PersonRecord A
	INNER JOIN #PersonRecord B
		ON A.PersonID = B.PersonID
		AND A.Version = B.Version-1
WHERE A.DEDate >= B.DEDate
GROUP BY PersonID

SELECT *, 
       (SELECT CASE 
          WHEN (SUM(CASE WHEN B.DEDate =1 
               THEN 1 ELSE 0 
        END AS isawk 
 	from #PersonRecord B INNER JOIN #PersonRecord C
		ON B.PersonID = C.PersonID
		AND B.Version < C.Version
	 WHERE B.PersonID=A.PersonID) AS [Is ImProper] 
from #PersonRecord A

SELECT A.PersonID, Version, DEDate, COALESCE(Improper,0) as Improper
FROM  #PersonRecord A
       LEFT JOIN (SELECT DISTINCT B.PersonID, 1 as improper
                      FROM #PersonRecord B
	             INNER JOIN #PersonRecord C
		ON B.PersonID = C.PersonID
		AND B.Version = C.Version-1
                      WHERE B.DEDate >= C.DEDate) as t
	ON A.PersonID = t.PersonID

insert into PersonRecord
select N,0,'11/12/2008'
from Numbers
where N between 4 and 11000

insert into PersonRecord
select N,1,'11/13/2008'
from Numbers
where N between 4 and 11000

insert into PersonRecord
select N,2,'11/10/2008'
from Numbers
where (N between 4 and 11000) and N % 100 = 0