did you try to execute that stored procedure you like to call so you can check if the stored procedure really executing?...

i'm assuming that the stored proc you like to call execute a script that put data into table and you like to put the data on to the main stored proc?

exec [other stored procname]

insert into tmptable(fields)

select fields from [other stored procname].tablename

insert into tmptable(fields)

select fields from tablename

select * from tmptable