Discuss "Returning a table in sp executed in an sp..." in the SQL Development forum.

Hi All,

I am trying to come up with an efficient way of handling a problem. I am executing a stored procedure to get a mailing list based on various criteria. This list, if under 200 names must follow a separate procedure to backfill itself. I am thinking that if it is possible, I might try executing another stored procedure from the first stored procedure to get those results. Then I have to add the results of the second procedure to the records obtained in the first procedure and output the results.

Is this possible? Can I evaluate the results of stored proc A from within stored proc B? Has anyone tried this?

__________________
"The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS

I answered my own question. I managed to make this into one procedure. I reasoned that it would be easier to maintain this way rather than having two similar procedures.

I accomplished this by adding additional temp tables to store the data while I worked with it. Thanks anyway!