Hi,
Currently 2008. No plans for 2012. In that case a 'partition by' using preceding rows would be a solution, right?

Kind regards.
Dennes

[p]Hi there,

I have made a recursive search for relations here.

What about this:

[/p]

Create Table connections(

from_node_id Int,

to_node_id Int,

)

Insert connections

Select 1, 2

Union All

Select 2, 3

Union All

Select 3, 4

Union...

Ah,

I thought replying to a post would make it a child of the original.

So a proper thank you for ChrisM@Work and offcourse

Matt Miller who solved my problem.

Now I...

Hi Luis,

Thank you very much for your thinking alongside!

Based on your solution the two other repliers solved my problem completely.

Next time ( hope not 🙂 ) I'll put ...