New answers tagged


You can do this using the following steps: Find the sequence groups per groupid List the sequence numbers you're expecting Use a partitioned outer join to join each groupid&grp to the list of sequence numbers Exclude rows where the sequenceno is null in the output. This will give you the missing sequence numbers along with which groupid and group they'...

Top 50 recent answers are included