Are all the columns in common between the 50 stored procedures? Even if you defined a temp table with enough columns to handle any of the stored procedures, you would still have to define which columns are going to be populated by the output of the stored procedures. For example
create table #temp (many many columns)
insert into #temp (colA,colB,colC)
exec stproc1
insert into #temp (colA,colC,colD,colE)
exec stproc2
insert into #temp (colA,colB,col,C,colD,colE,colF,colG...)
exec stproc99
There just isn't an "automatic" way to avoid all this with stored procedures.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills