[thelist] CF: Values transposition. Too ugly, needs a face lift.

[ron thigpen]

Frank wrote:

> Can anyone suggest a better way?

this doesn't speak directly to your specific issue, but i'll mention 
that i gave up on using parent/child ID relations in SQL to represent 
heirarchies some time ago.  mostly due to ugly recursive techniques 
required.

for my money, modified preordered tree traversal is the way to go.

google:
<http://tinyurl.com/9uc5a>

--rt