get data from one stored procedure to stored procedure

create table #return (code int null)

insert into #return EXEC('select count(*) from membertree ')
SELECT * FROM #return
DROP TABLE  #return