Data
MEMBERID OPTCODE LASTCHANGEDATE
79988302FD1 878 2008-05-10 00:58:17.283
79888302FD1 546 2008-05-10 00:58:17.020
88888302FD1 999 2008-05-10 00:58:17.020
69988302FD1 878 2008-05-10 00:58:17.283
68888302FD1 546 2008-05-10 00:58:17.020
Question?
I have a data set in SQL that I need to compare the previous record if it was changed based on MEMBERID if the OPTCODE has changed.
For example, memberid 79988302FD1's OPTCODE has changed, I need to be able to compare the previous record againts the current one.
Please advise.
Thanks.