Home Forums SQL Server 7,2000 T-SQL Sum then Divide RE: Sum then Divide

  • April 1, 2013 at 11:07 am

    #1602535

    ccmret (4/1/2013)

    The query successfully completed with your suggestion. Howerver, it returned a zero.

    Integer math, try:

    SUM(t_complete)/(COUNT (*) * 1.0) As Percent_Complete