Ακυρώθηκε

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.

Δεξιότητες: Microsoft SQL Server

Δείτε περισσότερα: firebird debug stored procedure, perl sql stored procedure, sql copy procedure, software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write technical manual, website loading indicator flash, virtuemart debug, php popup upon loading, instructions backgrounds business cards, swf loading animation, sample good software instructions

Σχετικά με τον Εργοδότη:
( 7 αξιολογήσεις ) Lincoln, United States

ID Εργασίας: #11792261

Ανατέθηκε στον/στην:

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 Περισσότερα

$150 USD σε 0 μέρες
(0 Αξιολογήσεις)
0.0

2 freelancers κάνουν προσφορές με μέσο όρο $200 γι' αυτή τη δουλειά

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 σε 2 μέρες
(0 Αξιολογήσεις)
0.0