MSSQL to MySQL – Foreword
Hey All,
Back again with the power of knowledge! Recently we have been helping out a client to turn an Excel document into a database as a part of a new online application. On our first pass, we had converted the excel formulas into MSSQL, but in the end the choice was made to move the production into a MySQL environment instead. Thus begins the conversion of syntax from MSSQL to MySQL. There are some subtle differences, of which some of them I would like to share here in the hopes of helping someone else in need. I will be posting the code translations in the future, so check back for more!