Sorry for the confusion, guys. Let's see if this explains it better. I have come across an issue where a table logs conditions with

a timestamp, eventid and eventtype. The condition 'Session_End_Prompt_Sent' with EventType = 11 is being logged before the condition

'LB_CLOSED_NEVER_STARTED' with EventType = 117. This is being logged typically within a few seconds, but definitely within a minutes

time of each other based on the Timestamp column. This should not happen. I need to know how many times this occurs within the table

but haven't been able to make a query work to get me that information.

Example:

Condition Timestamp EventID EventType

Session_End_Prompt_Sent 2012-09-04 00:08:00.7076468818 11

LB_CLOSED_NEVER_STARTED 2012-09-04 00:07:59.9236468833 117

Once again, any help is appreciated.