#12; create a sql-query for comparing 2 access-tables.
$30-250 USD
Fullført
Lagt ut nesten 12 år siden
$30-250 USD
Betalt ved levering
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
-
I have also created similar applications in my other projects.
I can do this work in best possible way any performance wise also it would be fast. I have all the skills which are required. In work in MNC so i know what a deadline is. So i will stuck to it.
Hi I am currently a Data Warehouse developer. In my job we always have to compare tables, I mean compare the transactional table with the data warehouse table to make sure that everything was loaded. Compare DEV with PRD to make sure that we are not losing records or data.