Nested SP

Question

Nested SP

balaji.ganga

SSCrazy

Points: 2280
More actions
September 21, 2010 at 4:50 am

#72061

Hi,
I had a nested sp.. In that sp.. i just need to execute a single sp alone from nested sp..
is there any way to execute it?
thanks in advance
Balaji.G

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I don't think you've given us enough information to intelligently answer your question.

Are you saying that you have 3 sps (sp_1, sp_2, sp_3) and sp_1 calls sp_2 which calls sp_3? Depending on what each sp is doing that can be done, but you can't nest Insert Into table Exec sp so that could be a problem.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

balaji.ganga SSCrazy Points: 2280 More actions · Answer 2

Hi Jack,

In that nested stored procedure having sp1 calls sp2 and sp2 calls sp3 and so on..

i need to execute a single sp alone from that nested sp?

Is it possible.. if possible, kindly let me know

Thanks

Balaji.G

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

I'm still not sure what you are asking? Yes you can call another sp from sp3.

What is the problem you are trying to solve?

Why do you need to nest sp's, especially to this level?

Can you actually share the code that you have written?

What have you tried so far?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

balaji.ganga SSCrazy Points: 2280 More actions · Answer 4

we ran the nested sp.. its getting error... its hard to find out.. so that only i 'll try to execute

a each sp's from nested sp..

thanks

balaji.g

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

balaji.ganga (9/21/2010)
we ran the nested sp.. its getting error... its hard to find out.. so that only i 'll try to execute
a each sp's from nested sp..
thanks
balaji.g

What is the error you are getting? I really want to help, but I'm not getting enough information to really help.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question