
December 30th, 2004, 02:25 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
nested stored procedure call
I would like to know how can I call a child stored procedure from a parent stored procedure. A child stored procedure will return a result set. Like,
return Select * from tblA where colA=@value.
@value will be passed from the parent SP. And in parent SP. I need to loop through the returned result set to do further processing.
The reason I want to have a seperate child SP is that I will need similar functionality in few other SPs. Any other solution will be appreciated.
Thanks in advance.
|