Thursday 8 November 2007

FFS why can't SQL do heirarchy tree things easily?

I don't care if its a recursive join. I can easily write a three column list, (id, part number, parent) all my parts and all their depenancies and with duplicate lines, and I can easily, by hand, layout the damned heirarchy tree ting, so why does the entire internet database admin community not have an easy bit of cut and paste SQL code that'll do it for me.

I've got 3GHz of speed, 1Tb of hard disk memory and 2Gb of RAM, it shouldn't matter if there are five levels of recursion or a hundred, this damned 'puter should figure it out in a few seconds and display it.

Lazyweb, help me!!

No comments:

Post a Comment