Porcentaje condicional con agrupacion de fechas

[jesus121]

Por si acaso no me he explicado bien, aquí dejo una mi consulta adapatada y el resultado de tuplas que he optenido:


SELECT DISTINCT anio, mes, dia, cont1, cont2, cont1 / ((cont1 + cont2) * 1.0) * 100 AS [%_si], cont2 / ((cont1 + cont2) * 1.0) * 100 AS [%_no]
FROM (SELECT YEAR(FechaRevision) AS anio, MONTH(FechaRevision) AS mes, DAY(FechaRevision) AS dia,
(SELECT COUNT(FirstCallResolution) AS Expr1
FROM Incident
WHERE (YEAR(FechaRevision) = YEAR(FechaRevision)) AND (MONTH(FechaRevision) = MONTH(FechaRevision)) AND
(DAY(FechaRevision) = DAY(FechaRevision)) AND (FirstCallResolution = 'si')) AS cont1,
(SELECT COUNT(FirstCallResolution) AS Expr1
FROM Incident AS Incident_2
WHERE (YEAR(FechaResolucion) = YEAR(FechaResolucion)) AND (MONTH(FechaResolucion) = MONTH(FechaResolucion)) AND
(DAY(FechaResolucion) = DAY(FechaResolucion)) AND (FirstCallResolution = 'no')) AS cont2
FROM Incident AS Incident_1) AS derivedtbl_1



RESULTADO
---------------
AÑO MES DIA cont1 cont2 %_si %_no
---- ---- ---- ------ ------- -------------------------- ------------------------
2007 4 2 719 2091 25,58718861209900 74,41281138790000
2007 4 7 719 2091 25,58718861209900 74,41281138790000
2007 4 19 719 2091 25,58718861209900 74,41281138790000



Un millón de gracias y perdonad por las molestias!