Following code is used to count number of rows in stored procedure.