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
