Cita:
Iniciado por iislas 
Muéstranos tu consulta, a mi en lo particular, no domino la adivinanza
Código SQL:
Ver originalSELECT DISTINCT
CASE WHEN VE.interno=0
THEN
SELECT SUM(acum) FROM
isnull
( SELECT (TD.BRUTO - isnull((SELECT (CANTIDAD*VALORUNIT) FROM MVTRADE WHERE TIPODCTONC IN ('NC','NB','NU') AND NUMFACTNC=TD.NRODCTO),0)) *
(SELECT (PorcReca/100)FROM GS_Recaudo WHERE (DATEDIFF(DAY, @pfecha,@pfecha) BETWEEN Desde AND Hasta))
* (SELECT (PorcReca/100) FROM GS_ConfEscal WHERE Nombre=VE.NOMESCALAFON) AS acum
FROM Trade AS TD
INNER JOIN GS_Recaudo AS RC ON RC.CodeVen = TD.CODVEN
INNER JOIN VENDEN AS VE ON VE.CODVEN = RC.CodeVen
LEFT JOIN ABONOS AS AB ON AB.FACTURA=TD.NRODCTO AND AB.TIPODCTOCA=TD.TIPODCTO
WHERE TD.TIPODCTO IN ('FU','FB','FC') AND TD.CODCC=VE.CCOSTOS AND TD.FECHA >= '2010-01-06' AND TD.FECHA1 <= '2010-01-06' AND VE.Interno=0
)
)AS total),0) END AS total
FROM venden AS VE
esta es como parametros envio la fecha