SQL 2005 Problem : Insert exec statement cannot be nested
-
Hi, I m having three store procedures 1. Test_1 2. Test_2 3. Test_3 in Test_1 i get output of one date in Test_2 i user Test_1 to get output of one week in Test_3 i want output of 7 weeks so for that when i use Test_2 in Test_3 i got error "Insert exec statement cannot be nested" please help me out of this. Thank you.
-
Hi, I m having three store procedures 1. Test_1 2. Test_2 3. Test_3 in Test_1 i get output of one date in Test_2 i user Test_1 to get output of one week in Test_3 i want output of 7 weeks so for that when i use Test_2 in Test_3 i got error "Insert exec statement cannot be nested" please help me out of this. Thank you.
I looked in my crystal ball, stirred the tea leaves, and tried the medicine man lodge and I was still unable to see your query. Do you think your could be so kind as to post it here so we might be able to fathom better your problem. I can not express how happy that would make all of us.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
-
I looked in my crystal ball, stirred the tea leaves, and tried the medicine man lodge and I was still unable to see your query. Do you think your could be so kind as to post it here so we might be able to fathom better your problem. I can not express how happy that would make all of us.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
Jerry Hammond wrote:
Do you think your could be so kind as to post it here
Apparently not - I wonder if it is embarassment or he considers his code too proprietry to post, or maybe he worked it out himself.
Never underestimate the power of human stupidity RAH
-
Jerry Hammond wrote:
Do you think your could be so kind as to post it here
Apparently not - I wonder if it is embarassment or he considers his code too proprietry to post, or maybe he worked it out himself.
Never underestimate the power of human stupidity RAH
No, his lawyer is preparing an NDA document for you to sign. :omg:
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
No, his lawyer is preparing an NDA document for you to sign. :omg:
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
Luc Pattyn wrote:
NDA
The National Association of Dyslexics? rofl... (I know what it really is btw...)
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
Luc Pattyn wrote:
NDA
The National Association of Dyslexics? rofl... (I know what it really is btw...)
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!