delete reapeated row with one column value
suppose i have a table like this
Date Name Entry
21-08-2012 A In
21-08-2012 A Out
21-08-2012 A In
21-08-2012 A In
21-08-2012 A Out
In this i need to check if first time out will be occurred in the entry column then an error must be generated otherwise it must go to the next record. We have to check everytime the sequence of "in" and "out" entry if "in" will occur twice in the continuous order then it should delete the first occurence of the "in" entry showing in continuous order...... Anyone can help me
I want output like this
Date Name Entry
21-08-2012 A In
21-08-2012 A Out
21-08-2012 A In
21-08-2012 A Out