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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 recursion in DB Functions

Author  Topic 

yarivmalka
Starting Member

1 Post

Posted - 2007-11-29 : 11:27:26
hi all ,

I want to build a recursive function that should get "Table" Parameter

can it be done ?

can any one send me example

regards,
Moshe Yariv Malka

Moshe Yariv Malka The seventh dimension

Jeff Moden
Aged Yak Warrior

652 Posts

Posted - 2007-12-01 : 21:28:06
Little bit of a language barrier thing going on here... what do you mean by "get Table Parameter"? Do you mean a parameter for a table name that can be used in a FROM clause? Inside a function, the answer would be "NO" because it would require dynamic SQL to do that. You can't run dynamic SQL inside a function.

Heh... what is this function supposed to do and why does it need to be recursive? Not enough information to really help here, Moshe. Please provide more.

--Jeff Moden
Go to Top of Page
   

- Advertisement -