Can't get stored procedure to work

@mdsmith1 As stated in the message, it's possible the syntax needs to be fixed based on MySQL version running? Perhaps @Tess or @Kabirdas can give more advice