Re: Error creating Stored Procedure

[Peter Brawley]

Let's see the MySQL version, the error message, and the result of ...

Show Create Table tblPrime;
Show Create Table tblPrimeUnitName;

Expressions like ...

STR_TO_DATE(LEFT(tblPrime.DateTimeStamp,
LOCATE('T', tblPrime.DateTimeStamp) - 1),
'%Y-%m-%d') AS DateStamp,
STR_TO_DATE(SUBSTR(tblPrime.DateTimeStamp, 12, 8),
'%H:%i:%s') AS TimeStamp,

... assume table data will conform to specific expectations; it's usually better practice to encapsulate such computations in functions with graceful error handling.

Likewise for expressions like ...

ROUND((tblPrimeUnitName.AIN6HR - tblPrimeUnitName.AIN6LR) / (tblPrimeUnitName.AIN6HV - tblPrimeUnitName.AIN6LV) * tblPrime.AIN6 + tblPrimeUnitName.AIN6HR - (tblPrimeUnitName.AIN6HR - tblPrimeUnitName.AIN6LR) / (tblPrimeUnitName.AIN6HV - tblPrimeUnitName.AIN6LV) * tblPrimeUnitName.AIN6HV,

... that are prone to division-by-zero errors.