Just a word of advice, place the entire business logic of recursion in a
stored procedure. What you do know, is make numerous calls to the
database server, which is by far, more slower and cpu intensive than
putting the job at SQL Server.


tSQL gives you enough functions and possibilities to get recursive
functions.


This means, you only call the database once, and then you get a nice
result set back ready to use.

Micha Schopman
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to