Adaptar uma pesquisa usando o Pivot.

DECLARE @INICIO DATETIME, @FIM DATETIME, @DATA DATETIME, @QUANTIDADE DECIMAL(10)
SET @INICIO = [DADO1]
SET @FIM = [DADO2]
SET @DATA = @INICIO
SET @QUANTIDADE = 0

WHILE @DATA <= @FIM
BEGIN
IF (DATEPART(WEEKDAY, @DATA) = 7)
SET @QUANTIDADE = @QUANTIDADE + 1

SET @DATA = DATEADD(DAY,1,@DATA)
END

SELECT
   R.CODLOJ+R.CODVEN+SUBSTRING((CONVERT(VARCHAR(10),((R.DATEMI - DAY(R.DATEMI)) +1),103)),4,8) AS CHAVE,
   CASE 
      WHEN R.CODLOJ='001' THEN '001 - LAPA'
      WHEN R.CODLOJ='002' THEN '002 - FREGUESIA'
      WHEN R.CODLOJ='003' THEN '003 - PINHEIROS'
      WHEN R.CODLOJ='004' THEN '004 - JUNDIAI'
      WHEN R.CODLOJ='005' THEN '005 - TATUAPE'
      WHEN R.CODLOJ='006' THEN '006 - OSASCO'
   ELSE 'SEM LOJA'
   END AS Loja,
   R.CODVEN+'-'+V.NOME AS VENDEDOR,
   SUBSTRING((CONVERT(VARCHAR(10),((R.DATEMI - DAY(R.DATEMI)) +1),103)),4,8) mesano,
   CASE 
      WHEN R.TIPOREQ = 'VD' THEN COUNT(R.NUMREQ) 
   ELSE 0 
   END AS QTDVDA,
   CASE 
      WHEN R.TIPOREQ = 'VD' THEN SUM(R.TOTGERAL) 
   ELSE 0 
   END AS TOTVDA,
   CASE 
      WHEN R.TIPOREQ = 'DV' THEN COUNT(R.NUMREQ) 
   ELSE 0 
   END AS QTDDEV,
   CASE 
      WHEN R.TIPOREQ = 'DV' THEN SUM(R.TOTGERAL) 
   ELSE 0 
   END AS TOTDEV,
   SUM(R.TOTGERAL) AS TOTAL,
   SUM(R.TOTGERAL) AS PARTIC,
   SUM(R.TOTGERAL*0) AS TIQMEDIO,
   SUM(R.TOTGERAL*0) AS MEDIAVDA,
   SUM(R.TOTGERAL*0) AS MEDIALIQVDA,
   (((SELECT
      (DATEDIFF(dd, [DADO1], [DADO2]) + 1)
      -(DATEDIFF(wk, [DADO1], [DADO2]) * 2)
      )+(@QUANTIDADE/3))-('[DADO5]')))        AS DUTEIS,
   (SELECT 
       SUM(R.TOTGERAL) 
    FROM  AS R
    WHERE (R.TIPOREQ = 'VD')
       AND(R.DATEMI >= [DADO1])
       AND(R.DATEMI <= [DADO2])
       AND(R.CODCPV NOT IN [DADO4])) AS TOTGERAL
FROM  AS R
LEFT JOIN  AS V ON(V.CODCLI=R.CODVEN)
WHERE (R.TIPOREQ IN ('VD','DV'))
   AND(R.DATEMI >= [DADO1])
   AND(R.DATEMI <= [DADO2])
   AND(R.CODVEN  = [DADO3])
   AND(R.CODCPV NOT IN [DADO4])
   AND(R.CODVEN NOT IN [DADO7])
GROUP BY R.CODLOJ,R.TIPOREQ,R.CODVEN,V.NOME,SUBSTRING((CONVERT(VARCHAR(10),((R.DATEMI - DAY(R.DATEMI)) +1),103)),4,8)
ORDER BY R.CODLOJ,R.CODVEN,SUBSTRING((CONVERT(VARCHAR(10),((R.DATEMI - DAY(R.DATEMI)) +1),103)),4,8)