Debug MS SLQ procedure

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 '[login to view URL]'; 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 '[login to view URL]'; 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, [login to view URL] 2) the data file, [login to view URL], this is the data that triggers the error 3) a data file that runs sucessfully, [login to view URL] 4) the SQL procedure, [login to view URL] 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.