Posted by Shuurai on 05/02/07 15:39

On May 1, 11:00 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
> "--CELKO--" <jcelko...@earthlink.net> wrote in message
>
> news:1178072664.340603.278310@o5g2000hsb.googlegroups.com...
>
> >>> Lists the contents of a table designed to represent a multi-branch
> >>> tree. The result set takes the form: ItemID TreeLevel Label Tree
> >>> traversal is done non-recursively (to avoid SQL Server's limit of 32
> >>> nested procedure calls) <<
>
> > Have you gotten a copy of TREES & HIERARCHIES IN SQL? There are
> > several ways to model trees without *any* procedural traversal code at
> > all.
>
> > You also have more NULL-able columns int his one table than the entire
> > payroll data base of a major automobile.
>
> Now I'm curious, how many cars have a payroll database. :-)

You gotta be careful... they'll try to sneak one in with their option
packages...

[Back to original message]