delete reapeated row with one column value

Aug 21 2012 6:16 AM

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

Answers (1)

How to convert Server time into Localtime in sql server 2005

A table without index in SQL