>>SELECT  p.PartNo, i.SerialNo AS Serial, i.PurchaseOrder, 
>>                      p.Description, u.FullName, 
>>		      w.Caption AS Warehouse, w.WarehouseCode, i.*
>>		FROM Inventory i
>>		JOIN Parts p ON p.PartId = i.PartId
>>		JOIN Warehouses w ON w.WarehouseId = i.WarehouseId
>>		JOIN Users u ON u.UserId = i.UserId
>>		WHERE i.WarehouseId = @WarehouseId AND i.LocationId = 0
>>			AND NOT EXISTS (SELECT 1 FROM Inventory i2 
>>				WHERE i2.WarehouseId  = i.WarehouseId  
>>					AND i2.PartId  = i.PartId 
>>					AND i2.LocationId  <> 0)
>>		ORDER BY p.PartNo, i.SerialNo
>>