Transaction Count Batch Stored Procedure

Submitted by mikehostetler on Thu, 04/26/2007 - 08:46

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

USE <

code>cics_app</code>;

DROP PROCEDURE IF EXISTS Transaction_CountBatchNumber;

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

 

SELECT
        COUNT(<code>transaction</code>.<code>batch_number</code>) INTO batch_count
   FROM
       <code>transaction</code>
  WHERE
      <code>transaction</code>.<code>batch_number</code> = batch_number;

 

SELECT batch_count;
END;
|
DELIMITER ;
?>
Taxonomy upgrade extras: 
mysql
cics
mysqli
stored procedure