locked
how to share table between stored procedure? RRS feed

  • Question

  • User-1883719206 posted

    hi,

    i have a stored procedure which creates a table and fills it up, this stored procedure call it self again and continue fill it up with more data.

    the problem is that between the calls the data on the temp table doesn't save. my question is how can i share a temp table which is created

    in the stored procedure between a subsequent calls of the same stored procedure, or between a different stored procedure?

    Saturday, July 14, 2012 12:51 PM

Answers

  • User1867929564 posted

    read this,

    http://www.sommarskog.se/share_data.html

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, July 14, 2012 2:16 PM