Viewing 3 posts - 1 through 3 (of 3 total)
Thanks I had exactly the same problem and used exactly the same solution.
June 4, 2009 at 2:26 am
#1004464
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...
November 12, 2008 at 7:33 am
#897521
Congratulations on a well-written and informative article.
August 19, 2008 at 8:48 am
#860055