Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Overlapping Times
Can't see all of it yet, but you need to compare records in the table against other records, so you need a self-join. You need a primary key (eventid) to prevent a row from joining itself. The same table must be listed twice in the FROM clause, and you do the join with set of conditions to...
