PFB the required code sample. Have 2 parameters as out parameters.
There is no need to pass any values while executing the procedure.
Create proc TestProc
@recordCountTable1 int out,
@recordCountTable2 int out
select @recordCountTable1=COUNT(*) from Table1
select @recordCountTable2=COUNT(*) from Table2
--The below query is to execute the procedure during execution
declare @recordCountTable1 int
declare @recordCountTable2 int
exec TestProc @recordCountTable1 out,@recordCountTable2 out
Raman S V