What is the fastest way to check a set of individual data lines against a from to range ?
Table Batch contains a range of invoices asked with a from and to invoice number. 1 row per batch_number
Table Invoices containts my actual invoices. 1 row per batch_number / invoice_number
However, for some reason, table Invoices sometimes does not contain some invoices as they cannot be processed by the interface process.
How can I easily script this ? I have the invoice_number_to and invoice_number_from in table Batch and I want to check which invoice numbers in between the range cannot be found in the table Invoices. Below is an example