Home Forums SQL Server 2008 SQL Server Newbies Convert Excel formula to SQL RE: Convert Excel formula to SQL<!-- 864 -->

  • This is very close but something else is slightly off...the third place team should be 2 games behind not 3

    This was the SQLfiddle statement:

    (ABS((SELECT MAX(Wins ) FROM WinLossSum) - Wins )) +

    (ABS(Losses - (SELECT MIN(Losses) FROM WinLossSum))) / 2.0 AS GamesBehind

    (6-4) + (2-0) / 2

    2+2/2=2 not 3

    The Result should be 2 so I am not sure how it is coming to 3?