Hi!

I have a table coming from a x.500 directory looking something like 
this:

3 fields
Distinguishedname							Adress		Telefon
-------------------------------------------------------------------------

ou=3Dse,ou=3Ddiv 1							Carson St 1		123123
ou=3Dse,ou=3Ddiv 1,ou=3Dunit a					Carson St 2		78976
ou=3Dse,ou=3Ddiv 1,ou=3Dunit a,ou=3Dsub unit 1			Carson St 4		123423
ou=3Dse,ou=3Ddiv 1,ou=3Dunit a,ou=3Dsub unit 1,ou=3Droom 12	Carson St 5		
321321
ou=3Dse,ou=3Ddiv 1,ou=3Dunit a,ou=3Dsub unit 2			Carson St 3		543543
ou=3Dse,ou=3Ddiv 2							Andes St 1		321321
ou=3Dse,ou=3Ddiv 2,ou=3Dunit a					Andes St 3		543543
ou=3Dse,ou=3Ddiv 2,ou=3Dunit a,ou=3Dsub unit 1			Andes St 2		321321
ou=3Dse,ou=3Ddiv 2,ou=3Dunit a,ou=3Dsub unit 2			Andes St 4		1231231
etc...

This table is imported once a day to SQL Server 2000 and will supposedly 
be used in a
ASP application. As you can see there are 1-to-many relationships within 
the table and the values separated by a comma may vary, from 2 up to 6 
values (sub-sub-units)

As far as I know SQL Server doesn=B4t support recursive joins. I am a 
bit confused which road to take to be able to use this kind of data 
(listings etc). Does anyone of you developers out there have some advice 
on how to deal with this kind of situation? Any advice is greatly 
appreciated.

Thanks,

Hakan