Home Forums SQL Server 2005 Administering Separate one column in many columns RE: Separate one column in many columns

  • June 17, 2013 at 7:50 pm

    #1624846

    Kingston Dhasian (6/14/2013)

    Change the final SELECT statement to something like this

    SELECT*, CAST( ( game1 + game2 + game3 + game4 + game5 ) / 5.0 AS NUMERIC(10,1) ) AS [percent]

    FROMcte_Students

    Thanks for your kind reply

    I am very grateful.