• Try this:

    Insert #temptablename

    exec <storedprocedure name>

     

    This will fill your temptable with results from the sp


    Regards,

    Anders Dæmroen
    epsilon.no