Can you answer jxflagg Last question?
I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now:
Suppose you have
TableChild (ChildID int, ParentID int , Property varchar (100))
You Could Do:
Declare @strAllChilds varchar(4000)
Declare @MasterRecordID int
SET @MasterRecordID = X
SELECT @strAllChilds = IFNULL(@strAllChilds + ',','') + Property From TableChild Where ParentID = @MasterRecordID
Can you post more info on how are you formating the output?
Edited by - noeld on 12/24/2003 09:47:10 AM