tags:

views:

21

answers:

0

Possible Duplicate:
Sql server recursive query

I have one table with 2 column EmpId,SupervisorId from that table i want data for example A guy can refer 3 guys under him i.e, 3 is referring three guys namely 4 5 8 similarly 4 is referring 9 10 and 11 likewise 8 is referring 12, 13 it goes like this..

I want a asp.net code to get all EmpId under Supervisor 3 from sql server database