stored procedure call in another sp

Question

Hi

I have one sp 

CREATE PROCEDURE [dbo].[GetDistinctPageNumber]
    
AS
BEGIN
    
    select Distinct PageNumber from MyTable order by PageNumber asc

END

 

which returns number from 1 to 22 as output.

 

Now, my requirement is get output from table on the basis of these pagenumber one by one in another sp

suppose pagenumber is 1 is pass through c# code than get all rows and columns which has pagenumber 1.

 

please help asap.