Select Categories Below
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.
Advertisement
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 an Answer Summary for the Summary 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
to select only last 7 days records in sql server 2...
You have 100 characters to use
Rank
Expert
Points
1.
1120
2.
1020
3.
965
4.
605
5.
345
6.
255
7.
210
8.
190
9.
105
10.
75
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 Real Estate Postcards Marketing Fulfillment