Thanks, here is an article that I got to from a search on the word
recursive on that site that. From a quick glance, looks like the structure
recommended by Celko in the latter chapters of his book, he goes into more
details on his reasoning in the book, which I highly recommend. I know it
took me a few reads in Celko's book to get the idea, but you can see where
breaking the normal, normalization standards for a tree structure may
actually be better for your applications as a whole in this instance. It's
a big debate that I'm not trying to start, I just think it's interesting to
hear how other peoples opinions differ from what we learned in school (or by
reading).
http://www.dbpd.com/vault/9811/kamfn.shtml
Also, Notice the example is of an org chart:)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Matthew Todd
Sent: Wednesday, September 18, 2002 1:02 PM
To: [EMAIL PROTECTED]
Subject: RE: SQL Question
This is the link to the articles that I sent you awhile back.
http://www.intelligententerprise.com/ports/search_celko.shtml
Matthew
>From: "Jacob Cameron" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: RE: SQL Question
>Date: Wed, 18 Sep 2002 09:34:35 -0500
>
>It's THE ANSI SQL book. Examples in Oracle, SQL, FoxPro, DB2, and others:)
>
>http://www.amazon.com/exec/obidos/tg/detail/-/1558605762/qid=1032359306/sr=
8
>-1/ref=sr_8_1/002-9478273-0984050?v=glance&s=books&n=507846
>
> Or just search for Joe Celko, he's the author and on the ANSI SQL
>committee for SQL '92 standard. Do a search on Google for him, he's got
>some good examples on the web that I've seen, but I'd have to find them.
> Matt, wasn't it you who sent me the links to his online articles?
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>Behalf
>Of Schreck, Tom
> Sent: Wednesday, September 18, 2002 9:16 AM
> To: [EMAIL PROTECTED]
> Subject: RE: SQL Question
>
>
> Where do you get SQL for Smarties?
>
>
>
> Thanks -
>
>
>
> Tom Schreck
>
> 817-252-4900
>
> [EMAIL PROTECTED]
>
>
>
> I have not failed. I've found 10,000 ways that won't work.
>
>
>
> - Thomas Edison
>
>
>
> -----Original Message-----
> From: Jacob Cameron [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2002 9:14 AM
> To: [EMAIL PROTECTED]
> Subject: RE: SQL Question
>
>
>
> Pickup the latest copy of SQL for smarties, the examples in chapter
>18,19,20 (I believe) are about recursion and the examples are positions
>within an org chart. Or if your on SQL 2k you can read this article for
>another approach:
>
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16123
>
> Basically, most discussions on recursion center around org charts.
>There are two major theories about how to do it best, one is recursion when
>you pull the data, the other is recursion when you update the tree. Both
>methods are discussed and compared in the later chapters of SQL for
>smarties.
>
>
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>Behalf
>Of Schreck, Tom
> Sent: Wednesday, September 18, 2002 8:47 AM
> To: [EMAIL PROTECTED]
> Subject: SQL Question
>
> I have a database of personnel which contains manager-employee
>relationship data. The personnel record contains the id of that person's
>manager (numManagerID). numManagerID points to another record within the
>personnel table. I need to have a recordset containing all personnel who's
>in a manager's organization, not just direct reports. Has anyone done
>something similar to this? I'm envisioning a lot of looping to build a
>recordset of all personnel within a given manager's organization. Any
>help/advice would be appreciated.
>
>
>
> Thanks -
>
>
>
> Tom Schreck
>
> 817-252-4900
>
> [EMAIL PROTECTED]
>
>
>
> I have not failed. I've found 10,000 ways that won't work.
>
>
>
> - Thomas Edison
>
>
>
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
