como saco un porcentaje

[GeriReshef]

Yo lo haría así:

Código SQL:

SELECT  *,
        CAST(total AS FLOAT)/SUM(total) OVER()
FROM    (SELECT status_rte AS STATUS, 
            COUNT (*) AS total
        FROM    TWREGISTROTEL 
        WHERE   FECHA_RTE >= CONVERT (datetime,'2012-07-01 00:00:00',102)
            AND FECHA_RTE <= CONVERT (datetime,'2012-07-31 23:59:59',102)
            AND STATUS_RTE NOT LIKE '11%' 
        GROUP BY STATUS_RTE) T
ORDER BY STATUS DESC;