DECLARE @HistoricoProduto TABLE (id int, prodid int, caddate datetime) INSERT INTO @HistoricoProduto VALUES (714640, 99608,'2010-02-21 17:27:38') INSERT INTO @HistoricoProduto VALUES (714641,101899,'2010-02-22 17:27:38') INSERT INTO @HistoricoProduto VALUES (714638,101226,'2010-02-23 17:20:03') INSERT INTO @HistoricoProduto VALUES (714639,101234,'2010-02-24 17:20:03') DECLARE @Romaneio TABLE (id int, valor int, caddate datetime) INSERT INTO @Romaneio VALUES (769291,2459.06,'2010-02-21 16:57:14') INSERT INTO @Romaneio VALUES (769290,3055.14,'2010-02-22 16:34:23') INSERT INTO @Romaneio VALUES (769289,1064.73,'2010-02-23 15:34:03') INSERT INTO @Romaneio VALUES (769288,2055.85,'2010-02-24 15:29:17') SELECT Hist.ProdId AS ProdId, Hist.CadDate AS StartDate, SUM(Roma.Valor) AS Sales FROM (SELECT ProdId, MAX(CadDate) AS CadDate FROM @HistoricoProduto GROUP BY prodid) Hist INNER JOIN @Romaneio Roma ON Hist.CadDate <= Roma.CadDate GROUP BY Hist.ProdId, Hist.CadDate