Show gaps in sequence?

[brmstr]

Hi there,

I'm interested if there's a solution to this:

Say you have an attribute in which you expect a sequence number with a stepping of 1.

Now I'd like to report on all the gaps in this sequence between the min and the max existing in the elements list.

Example:
"sequence" contains 5, 8, 10

report result expected: 6, 7, 9


Thanks,
Bob

 

[FLB]

Do you have access to another table that contains all the number (i.e. no gap)?

If yes, then I see at least one solution.

FLB