>>
>>I'm trying to modify this query so that it only looks at the latest record in a batch.
>>
>>

>>SELECT i.*, p.PartNo, p.Description, l.Location, w.WarehouseCode, w.Caption AS Warehouse, w.WarehouseId
>>	FROM Inventory i
>>	JOIN Parts p ON p.PartId = i.PartId
>>	LEFT JOIN Locations l ON l.LocationId = i.LocationId
>>	LEFT JOIN Warehouses w ON w.WarehouseId = i.WarehouseId
>>	WHERE p.PartNo = @PartNo AND
>>		  (@SerialNo IS NULL OR i.SerialNo = @SerialNo) AND
>>		  w.WarehouseId = @WarehouseId AND
>>		  i.LocationId IS NOT NULL AND
>>		  l.RemoveFromInv = 0
>>

>
>What does define the last record in a batch? Is it last by the date?
>
>See
>
>Including an Aggregated Column's Related Values

Yes, the ActionDate column.