Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2002-02-08 : 11:18:08
|
| Hi,Can I have recirsive UDF's?if yes, how do i call it from within?Thank yousam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 11:24:32
|
| Yes. Just call the UDF from within like you normally would, but make sure that the UDF tests for error conditions as well as exit conditions (upper limit reached, etc.) and have it exit out with a RETURN(NULL) statement. |
 |
|
|
|
|
|
RECURSIVE udf