Форум пользователей MySQL

  DECLARE curFrag CURSOR FOR
    SELECT id, name, space, distance, (space + IF(space=quant_left,10,0) - distance - ABS(space - quant_left)*2) AS rate
    FROM temp_distance
    ORDER BY rate DESC, name;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

  SET done = 0;
  SET quant_left = quant;
  OPEN cur1;
  frag: REPEAT

      FETCH cur1 INTO tid, tname, tspace, tdistance, trate;
      IF done OR quant_left<=0 THEN LEAVE frag; END IF;
      IF quant_left < tspace THEN
          SET tquantity = quant_left;
      ELSE
          SET tquantity = tspace;
      END IF;

      SET quant_left = quant_left - tquantity;

  UNTIL done OR quant_left<=0 END REPEAT;
  CLOSE cur1;