Cerrado

Debug MS SLQ procedure

Este projecto fue adjudicado a johns1986 por $150 USD.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
$30 - $250 USD
Ofertas Totales
2
Descripción del Proyecto

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.

Adjudicado a:
Habilidades Requeridas

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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