Home Forums Article Discussions Article Discussions by Author Discuss content posted by Divya Agrawal Compare Dates in an iterative manner for a particular set of records RE: Compare Dates in an iterative manner for a particular set of records
AlexT-359331
SSC Veteran
Points: 219
More actions
November 13, 2008 at 8:30 am
#898137
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