Debug MS SLQ procedure
Budget $30-250 USD
Debug MS SLQ procedure
The attached MS SQL procedure has been running without issue for a number of years. The latest attempt to run it returned the following errors.
Msg 515, Level 16, State 2, Line 779
Cannot insert the value NULL into column 'PDCNT', table '[url removed, login to view]'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
(1 row(s) affected)
Msg 515, Level 16, State 2, Line 849
Cannot insert the value NULL into column 'Y4GFTAMT', table '[url removed, login to view]'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
The job is to resolve the errors, get to the expected outcome, and document the code. Solution should be compatible with MS SQL 2008 R2.
Attached are
1) the instructions for loading the data, [url removed, login to view]
2) the data file, [url removed, login to view], this is the data that triggers the error
3) a data file that runs sucessfully, [url removed, login to view]
4) the SQL procedure, [url removed, login to view]
5) a sample of what the expected output is which has been copy/pasted into an excel file, SampleOutput
The only documentation available is included here.
The job time frame is 2 days.
1 Freelancer bietet durchschnittlich $250 für diesen Job
Hi, I'm currently working as Software Developer at IBM. I would be glad to help you with your database. Please contact me if you have any questions. Best, Sarkhan