Home Forums SQL Server 2008 SQL Server 2008 - General Query Help RE: Query Help

  • July 7, 2015 at 7:24 am

    #1810699

    SELECT

    SCHOOLID

    ,MAX(STATUS) STATUS

    FROM #TEMP

    GROUP BY SCHOOLID

    ORDER BY SCHOOLID

    John