johnkainn
asked on
select string parentitems
I have a table with the columns: Id, ParentId, MyText
I would like to get all parentitems in a string, i.e.
Id=100, ParentId=50, MyText='House'
Id=50, ParentId=30, MyText='Boat'
Id=40, ParentId=20, MyText='Truck'
Id=20, ParentId=0, MyText='Bicycle'
The result should be a string: 'Boat, Truck, Bicycle'
How is best to do that?
I would like to get all parentitems in a string, i.e.
Id=100, ParentId=50, MyText='House'
Id=50, ParentId=30, MyText='Boat'
Id=40, ParentId=20, MyText='Truck'
Id=20, ParentId=0, MyText='Bicycle'
The result should be a string: 'Boat, Truck, Bicycle'
How is best to do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER