Tag: mssql

    • SQL – MAX/Greatest()

    Hey all, this is the first big conversion I ran into with MSSQL and MySQL. In Excel, you can use the MAX() function to find the highest value in a row. =MAX(A1, B1, C1) When this is converted into MSSQL, we need to use an additional function in order to find this result. SET MaxValue […]

    Read More
    • Tech
    • Comments Off on MSSQL to MySQL – Foreword
    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 […]

    Read More