recursive call in stored proc

[Robert Song]

Hi all

I am implementing a stored procedure which needs to recursively call
itself until specific condition is reached, Could anyone give some
advice about that?

Thanks a lot

Robert Song

[John Gilson]

"Robert Song" <ro*********@mda-software.com> wrote in message
news:fb**************************@posting.google.c om...

Hi all

I am implementing a stored procedure which needs to recursively call
itself until specific condition is reached, Could anyone give some
advice about that?

Thanks a lot

Robert Song

One caveat is that the limit to the number of recursive calls to a procedure
is 32, that is, the count of the initial call and the subsequent recursive calls
must not be greater than 32. If you can't guarantee respecting this upper bound,
iteration might be the way to go. Even if you can, iteration might still be more
efficient than recursion. However, if you can guarantee not exceeding the
magic number 32 and the procedure is more clear recursively than
iteratively, then I'd go that way.

--
JAG

[Robert Song]

Hi John,

Thank you John, I'v got it.

Any way the reason I post this issue is: previously when i debugged
the SP of recursive call in Sql Query Analyzer I used the F10(step
over) key and it did't work. Today after read your respone, i feel
confident to debug it again. I used the key of F11(Step in) , It
works!

Thank you.

Robert Song

[--CELKO--]

>> I am implementing a stored procedure which needs to recursively
call itself until specific condition is reached, Could anyone give
some advice about that? <<

Not without seeing the code first :) This request is so vague, I am
tempted to reply with "Fire good! Poison bad!"

Generally speaking, T-SQL is not a good programming language, so you
should never write anything complicated in it. Are you using
recursion because the table design is wrong? I am always scared when
someone asks for how to implement a solution they have already decided
on; the right way to ask for help is to state the problem first.
Example: "what is the best kind rock for smashing screws into wood?"
The question excludes "use a screwdriver" and seeks the simple answer
"Granite!"