Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

=CONCATENATE("UPDATE msr_vpn_availability SET ",I1,"=",TEXT(F1*100,"0.00")," WHERE nren_name ='",H1,"' AND year =",A1," AND month = ",B1,";")

In column K of the spreadsheet paste the following Microsoft Excel Function:

=CONCATENATE("UPDATE msr_service_availability SET outage ='",TEXT(E1,"hh:mm:ss"),"', avail = ROUND(",F1,",4) WHERE service_name ='",H1,"' AND year =",A1," AND month = ",B1,";")

Complete the rest of the rows and copy the SQL statements.

...