All - I've got a table that has an unsigned int that stores increasing sequence numbers that are stored in UDP payloads. Occasionally, messages get lost and we'll have missing numbers in the sequence. These are not auto_incrementing columns, the sequence numbers are assigned by the application that generates the network traffic.
What's the easiest way to identify gaps in the sequence numbers? For example, sequence numbers might look like the following: 100, 101, 102, 112, ... How can I easily detect the gaps? Thanks, Mark Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] Office: (732) 528-9305 Fax: (732) 528-9308 Cell: (732) 996-7630