• 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