RE: SubProcedure (Subroutines) within Stored Procedure

SSC Guru

Points: 186127

January 7, 2014 at 8:17 am

skb 44459 (1/7/2014)
Do you have an example ? I don't necessarily want different Stored Procedures.
I need multiple SubRoutines within One Stored Procedure, so that they can share the Variables and Temp Tables.

Can you post up one such "subroutine"? It would help folks to visualise what you are trying to do.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden