Answers
Apr 12, 2007 - 02:16 AM
there is this tutorial here that may help you - it tackles using the result set one one stored procedure in another. http://www.sommarskog.se/share_data.h...
Apr 12, 2007 - 02:17 AM
The key to having values returned to a procedure that calls another procedure is to append the word 'output' to the variables in both the exec statement of the calling procedure, and the parameter declaration section of the called procedure
Apr 12, 2007 - 02:26 AM
thanks, looks like that was what I needed. I don't remember how I got around the problem then, but you'll get points for this anyway.
Apr 12, 2007 - 02:52 AM
alright, good luck. And thanks for my first points in this forum that Ive just joined :)
Add New Comment