Good Afternoon,

Got a rather complex brain teaser for you. Please review my sample data....

TableA

LNAME        ADDR1          ARRIVAL             DEPARTURE        CODE
Smith         12House         4/29/2008               5/2/2008
AB
Smith         12House         5/2/2008                 5/6/2008
AB      
Smith         12House         5/6/2008                 5/13/2008
AB
Smith         12House         5/13/2008               5/20/2008
AB
Smith         12House         5/5/2008                 5/11/2008
AB
Smith         12House         5/10/2008               5/13/2008
AB
Smith         12House         5/10/2008               5/17/2008
AB

Now please notice that the first 4 rows are part of a sequential set. What I
would like to happen is identify the non sequential records (the last 3) and
have them sent to a "holding table". Anyone up for tackling this beast?
Please take note that the non-sequential sample records purposely fall
within/on the ranges of the arrival/departure dates of the sequential records.
Perhaps the solution is to first pull out the sequential records? That would
work also. Thank you!!!!!!!!