<?php
--
-- Transaction Count Batch Number Stored Procedure
--

USE `cics_app`;

DROP PROCEDURE IF EXISTS Transaction_CountBatchNumber;

DELIMITER |
CREATE PROCEDURE Transaction_CountBatchNumber (IN batch_number INT)
BEGIN
    DECLARE batch_count INT;

    SELECT
        COUNT(`transaction`.`batch_number`) INTO batch_count
    FROM
        `transaction`
    WHERE
        `transaction`.`batch_number` = batch_number;

    SELECT batch_count;
END;
|
DELIMITER ;
?>

‹ Transaction Batch Balance Stored ProcedureupTransaction Max Batch Number Stored Procedure ›