Problema de consulta en sql

[mcovenas]

Problema resuelto

SELECT TOP (100) PERCENT dbo.DetAlmIngIns.IDproinsumo, dbo.DetAlmIngIns.PrecioCosto, dbo.AlmIngIns.FechaIng, dbo.AlmIngIns.FechaReg
FROM dbo.DetAlmIngIns INNER JOIN
dbo.AlmIngIns ON dbo.DetAlmIngIns.IDalmingins = dbo.AlmIngIns.IDalmingins INNER JOIN
(SELECT TOP (100) PERCENT DetAlmIngIns_1.IDproinsumo, MAX(AlmIngIns_1.FechaIng) AS Expr1, MAX(AlmIngIns_1.FechaReg) AS Expr2
FROM dbo.AlmIngIns AS AlmIngIns_1 INNER JOIN
dbo.DetAlmIngIns AS DetAlmIngIns_1 ON AlmIngIns_1.IDalmingins = DetAlmIngIns_1.IDalmingins
WHERE (AlmIngIns_1.Anulado = 0)
GROUP BY DetAlmIngIns_1.IDproinsumo
ORDER BY DetAlmIngIns_1.IDproinsumo, Expr1, Expr2) AS Temp ON dbo.DetAlmIngIns.IDproinsumo = Temp.IDproinsumo AND
dbo.AlmIngIns.FechaIng = Temp.Expr1 AND dbo.AlmIngIns.FechaReg = Temp.Expr2
WHERE (dbo.AlmIngIns.Anulado = 0)
ORDER BY dbo.DetAlmIngIns.IDproinsumo


Dejo el Codigo por si a alguien le interesa
Gracias