we have 2 tables with a structure like follows.
there are for each day 96 records (quarterhours)
now we want to compare each of the 96 values in table1 withe the same values in table2 (identic structure).
we need a small analysis for the differences between the tables in %.
The start screen for this query should have a few input possibilities:
- compare for "customerNr" / "counterNr"
- compare day or from date -> to date
- send a statistic to printer