終了

Debug MS SLQ procedure

このプロジェクトは$150 USDjohns1986へアワードされました。

このようなプロジェクトの無料見積もりを取得
作業中の採用者
プロジェクト予算
$30 - $250 USD
入札合計
2
プロジェクト情報

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.

アワード:

お金を稼ぎたいと思っていますか?

  • 予算と期限を設定してください
  • 提案のアウトラインを作成してください
  • 仕事の報酬を受け取りましょう

このプロジェクトにも入札したフリーランサーを採用する

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