I have a table that has been populated with change events ie where data has changed between months.
In some cases where there are two or more events the data value has gone back to its original value and i want to filter those out.
it could only happen where there is an even number of events for that particular code.
in the example shown its gone from M to A in 2012-07 and then back to M in 2012-08 so in effect no change took place.
SELECT TblTransmission.ChangeId, TblTransmission.AbiCode, TblTransmission.TransmissionPrev, TblTransmission.TransmissionChange, TblTransmission.ChangeYearMonth