I don't know if MSSQL 8 will do this, but here is the issue. I am building a membership system that needs to track up to 3 levels on who recommended whom. Here is a quick example:
Person1 signs up Person2
Person2 signs up Person3
Person3 signs up Person4
In a table I need to show that not only Person1 is resposible for Person2, but also Person3,Person4
It also needs to show that Person2 is responsible for Person3&Person4 as well as
Person3 is responsible for Person4.
I am not sure if a query will do this, any assistance would be appreciated. By the way this is a webbased coldfusion site.