SQL report repair and totals reconciliation by Jasper AddymanSQL report repair and totals reconciliation by Jasper Addyman
SQL report repair and totals reconciliationJasper Addyman
Cover image for SQL report repair and totals reconciliation
If a SQL report shows totals that don’t match the source records, I’ll trace the discrepancy and repair one existing report query. Typical causes include joins that count the same invoice twice, filters that drop rows, and calculations that group records at the wrong level.
You’ll receive the revised SQL, a before-and-after comparison against up to three agreed control totals or sample cases, and a short handover explaining the cause and how to rerun the checks. One in-scope revision is included.
The fixed price covers one read-only report query, up to four source tables and one reproducible discrepancy. Please share the database engine and version, the query, relevant table definitions, redacted sample rows and the expected result. I’ll confirm scope before you place an order.
Delivery is three working days from agreed scope and usable inputs. Database migrations, production writes, performance tuning and dashboard redesign can be scoped separately.
Starting at$195
Duration3 days
Tags
SQLite
Service provided by
Jasper Addyman Bristol, UK
SQL report repair and totals reconciliationJasper Addyman
Starting at$195
Duration3 days
Tags
SQLite
Cover image for SQL report repair and totals reconciliation
If a SQL report shows totals that don’t match the source records, I’ll trace the discrepancy and repair one existing report query. Typical causes include joins that count the same invoice twice, filters that drop rows, and calculations that group records at the wrong level.
You’ll receive the revised SQL, a before-and-after comparison against up to three agreed control totals or sample cases, and a short handover explaining the cause and how to rerun the checks. One in-scope revision is included.
The fixed price covers one read-only report query, up to four source tables and one reproducible discrepancy. Please share the database engine and version, the query, relevant table definitions, redacted sample rows and the expected result. I’ll confirm scope before you place an order.
Delivery is three working days from agreed scope and usable inputs. Database migrations, production writes, performance tuning and dashboard redesign can be scoped separately.
$195