Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Closed Points: 100 Time: 04:26 - Nov 21, 2006
dustPuppy
I'm programming some stored procedures on an MS SQL Server 2000 (T-SQL). I want to call a stored procedure (A) from within a stored procedure (B) and then do a select on the result from A, before returning it as the result of B. I'm doing this in order to reuse A instead of duplicating it and adding the other criteria, but I can't figure out how to get it to work. Can anybody help with this?
Categories:
Add Categories
When adding more than one category, separate them with commas.
nidhi
Date:: Apr 12, 2007
Time:: 05:16
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.html
Time:: 05:17
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
Time:: 05:26
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.
Time:: 05:52
alright, good luck. And thanks for my first points in this forum that Ive just joined :)
Question Answered
This question has been closed, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
HOW WE CALL STORED PROCEDURE IN ANOTHER PROCEDURE
to select only last 7 days records in sql server 2005
How do i pass a table variable or temp table as a input paramenter to a store...
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software