Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE `aspos`;
- DROP PROCEDURE IF EXISTS `sp_correlativo`;
- DELIMITER $$
- USE `aspos`$$
- CREATE PROCEDURE `sp_correlativo`(IN documentoId INT)
- BEGIN
- UPDATE documento SET correlativo = (SELECT IFNULL(MAX(a.numero)+1,documentoId) FROM egreso_cab a WHERE a.documento_id = documentoId) WHERE id = documentoId;
- SELECT correlativo, crr_ini, crr_fin, crr_min FROM documento WHERE id = documentoId;
- END
- $$
- DELIMITER ;
Add Comment
Please, Sign In to add comment