SELECT
_PNO,
COALESCE(_Result,'-') AS _Result,
COALESCE(_Analysis,'-') AS _Analysis,
COUNT(*) AS _Count,
CAST(100 * COUNT(*) / T._Total AS NUMERIC(0,1)) AS _Percentage
FROM CallStats
JOIN
(
SELECT COALESCE(_Result,'-') AS _Result, COUNT(*) AS _Total
FROM CallStats
WHERE
_fkProjects = :ProjectID
AND
_PNO = :PNO
AND
_Date BETWEEN :StartDate AND :EndDate
GROUP BY _PNO,COALESCE(_Result,'-')
) T ON COALESCE(T._Result,'-') = COALESCE(_Result,'-')
WHERE
_fkProjects = :ProjectID
AND
_PNO = :PNO
AND
_Date BETWEEN :StartDate AND :EndDate
GROUP BY _PNO,COALESCE(_Result,'-'),COALESCE(_Analysis,'-')