SELECT
        SUM(CASE WHEN tr.TestOverallResult = 1 THEN 1 END) AS Failures,
        SUM(CASE WHEN tr.TestOverallResult = 0 THEN 1 END) AS Successes,
        5 as test

    FROM
        dbo.TestResults tr
    WHERE
        tr.MethodCode LIKE '%' + @MethodName + '%'