Cancelled

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 '[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.

Skills: Microsoft SQL Server

See more: procedure to follow to design a logo on a deaktop computer ms word, firebird debug stored procedure, perl ms sql stored procedure, ms sql stored procedure send mail, ms sql stored procedure resize image, ms sql copy procedure, execute ms sql stored procedure perl script, copy data command stored procedure ms sql, convert ms stored procedure oracle package, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual, website loading indicator flash

About the Employer:
( 8 reviews ) Lincoln, United States

Project ID: #11792261

Awarded to:

johns1986

Hi, My name is John, I am a Professional Programmer since 2008, I have many programs developed and successfully finished in my past employer, I am expert in IT Industry both Hardware and Software Programming, I will More

$150 USD in 0 days
(0 Reviews)
0.0

1 freelancer is bidding on average $250 for this job

serxanbayramli

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

$250 USD in 2 days
(0 Reviews)
0.0