lordhurley

Srs, boa tarde! Preciso realizar um consulta em minha tabela "cadlog" e com a coluna "logstat" fazer percentual (quantos % 5, 7,6 etc..). Já tentei diversas formas mas não consigo. A seguinte query: select LogDtHora, LogStat, LogServ, LogRota = '17' from cadlog where LogDtHora between '2018-09-04 08:00:00' and '2018-09-04 21:00:00' order by LogDtHora Me traz: LogDtHora LogStat LogServ LogRota 2018-09-04 08:00:06.910 7 9 17 2018-09-04 08:00:07.613 5 9 17 2018-09-04 08:00:07.717 7 9 17 2018-09-04 08:00:07.943 15 5 17 2018-09-04 08:00:09.317 7 9 17 2018-09-04 08:00:09.437 6 1 17 Já tentei as seguintes querys: 1º declare @total int select @total=count(*) from cadlog select logdthora, COUNT([logstat]), logserv, logrota = '17', 100*COUNT([logstat])/@total as [percentual] from cadlog where LogDtHora between '2018-09-04 08:00:00' and '2018-09-04 10:00:00' order by LogDtHora 2º select LogDtHora, COUNT ([logstat]) , LogServ ,LogRota = '17', (COUNT[logstat] / SUM([logstat])*100) as [percentual] from cadlog where LogDtHora between '2018-09-04 08:00:00' and '2018-09-04 21:00:00' Porém sempre da erro e não compila. Att.