SQL Server Query Failure Analysis
Budget: $30 – $250 USD
Thousands of lines of T-SQL that once worked are now returning incorrect results. I need a fresh set of expert eyes to comb through the entire script, pinpoint exactly where the logic breaks down, and fix it. The code lives in SQL Server.
While you work through the main script, I also need you to cascade several hundred new parameters into a series of dependent stored procedures. These procedures already compile; they simply require the additional parameters to be wired through correctly so downstream calculations stay consistent.
What I expect from you:
• A clean, corrected version of the original query and any touched procedures
• A concise change log explaining the root cause of the logical error and how you resolved it
• Updated stored procedures with the new parameters fully integrated and tested
• A brief validation script or sample run that proves the results are now accurate
If you can move quickly and document clearly, let’s get started right away.
While you work through the main script, I also need you to cascade several hundred new parameters into a series of dependent stored procedures. These procedures already compile; they simply require the additional parameters to be wired through correctly so downstream calculations stay consistent.
What I expect from you:
• A clean, corrected version of the original query and any touched procedures
• A concise change log explaining the root cause of the logical error and how you resolved it
• Updated stored procedures with the new parameters fully integrated and tested
• A brief validation script or sample run that proves the results are now accurate
If you can move quickly and document clearly, let’s get started right away.