Recursive Problem

microsoft.public.sqlserver.programming

2 Sep 2005 7:30 AM

bali

Hi,

I have a table say table1 whose structure would be
Value1, Value2.
Lets assume i have the following values in the Table1.

Value1 Value2
1      2
2      3
3      4
4      1
8      1

The output that i would like to have is :

Value1 Value2
1      2
2      3
3      4
8      1

since the value2 4 which is indirectly related to value1 1(like 1-2,2-3,3-4 so indirectly 1 is related to 4), i don't want that to be displayed. I strongly believe the solution could be achieved through a recursive call.

Any advice on this would be great.

Thanks a lot.

Bali. -- bali ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------