Can you execute a proc from another proc

Dataset 1 is the correct dataset I expect from sproc A but that dataset is going into a temp table and then doing a quick aggregation, which is returned as blank in dataset 2. I'm wracking my brain here on what could possibly be an issue and I'm not finding it. What am I missing here? It looks literally the same as the one I did before that worked beautifully.

SprocA runs fine by itself, returning the data like it should. But this one looks like it's just executing the stored proc and displaying the data rather than inserting it into the temp table.

The issue here wasn't with SprocB. It was with SprocA and the code to insert into the table defined in SprocB:. You must be logged in to reply to this topic. Login to reply. October 14, at pm Hello, Wondering if anyone has any insight into how I can do this: I have a lengthy stored proc which produces a number of metrics that I may need to use for other calculations. Any ideas? Not sure I understand. I'd have to see the proc's code to be any more specific than that.

October 15, at pm I'm sorry guys, I'm just not seeing it for whatever reason. Do I have that right? Can you hear how unsure I am here? So how do I actually do this? October 17, at am I think you misunderstood what I explained or you didn't implement it correctly. September 9, at AM. How do I call a procedure into another procedure. Knowledge Base Insert. Log In to Answer. Related Questions How do you get the column names for a foreign key constraint?

Number of Views 8. Number of Views 4. Number of Views 2. Number of Views 5. Nothing found. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile. Linked Related Hot Network Questions. Question feed.