Posted by christopher.secord@gmail.com on 10/17/06 19:56

Henrik Juul wrote:
> CREATE PROCEDURE dbo.GetParentIONode

Henrik, I did something very similar to what you're trying to do here
and explained it in this post:

http://groups.google.com/group/comp.databases.ms-sqlserver/browse_frm/thread/912f2242e783204d

It is non-recursive and, I think, a bit faster than the recursive
method.

[Back to original message]