Geschlossen

Debug MS SLQ procedure

Dieses Projekt wurde johns1986 für $150 USD vergeben.

Erhalten Sie kostenlose Angebote für ein Projekt wie dieses
Arbeitgeber arbeiten
Projektbudget
$30 - $250 USD
Angebotsanzahl
2
Projektbeschreibung

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.

Vergeben an:
Erforderliche Fähigkeiten

Möchten Sie Geld verdienen?

  • Legen Sie Ihr Budget und Ihren Zeitraum fest
  • Skizzieren Sie Ihr Angebot
  • Bekommen Sie Geld für Ihre Arbeit

Heuern Sie Freelancer an, die auch auf dieses Projekt geboten haben

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online