CREATE OR REPLACE PROCEDURE
    Items1stPage( IN Page_size INT, OUT Total_rows INT )             
BEGIN
    SELECT SQL_CALC_FOUND_ROWS
        *
    FROM
        SalaryReport( NOW() )
    LIMIT
        Page_size
    ;    

    SET 
        Total_rows = FOUND_ROWS()
    ;
END
