Posted by Greg D. Moore \(Strider\) on 05/02/07 03:00

"--CELKO--" <jcelko212@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. :-)




--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

• Next in forum: changing IP addresses of MS SQL server in clustered environment
• Prev in forum: Re: Need to go down path to find if everything is settled (recursive possibly)
• Thread view: Re: Need to go down path to find if everything is settled (recursive possibly)

[Reply to this message]