<?php
--
-- Transaction Maximum Unit Number Stored Procedure
--

USE `cics_app`;

DROP PROCEDURE IF EXISTS Transaction_MaxUnitNumber;

DELIMITER |
CREATE PROCEDURE Transaction_MaxUnitNumber ()
BEGIN
    DECLARE unit_number INT;

    SELECT
        MAX(`transaction`.`unit_number`) INTO unit_number
    FROM
        `transaction`;

    SELECT unit_number;
END;
|
DELIMITER ;
?>

‹ Transaction Unit Balance Stored Procedureup