Sorry..if my requirement is not clear...It is something like this

CREATE PROCEDURE pr_GetAllChildrenWithParentList

(@input Varchar(8000),

@Result Varchar(8000) OUTPUT )

.....

When @input=1,3

@Result=1,2,3,4,5,6,7,8

When @input=2,7

@Result=2,5,6,7,8

Its like traversing the tree till leaf node.Hope it...

To be more clear here is the thing which iam looking for

Family Table with two columns

parent int

child int

The table can be like

parent child

1 2

1 3

1 4

2 5

2...