Re: A tree of location and site names..

Dear Hugo,

Thank you very much for your considered thought on my questions. Your
thoughts and suggested reference material were helpful to draw this to a
resolution.

Thank you again :)

Cheerio
Rhonda

"Hugo Kornelis" wrote:

> On Fri, 13 May 2005 08:22:02 -0700, Rhonda Fischer wrote:
>
> >Hello,
> >
> >This is a tuff one not sure if it can be done with an SQL query, I'm
> >thinking along the lines of an inner join, but I'm not really sure.
> (snip)
>
> Hi Rhonda,
>
> Sorry for the late reply.
>
> I'm not sure what exactly you're asking. Your message doesn't appear to
> have any specific question. Are you looking for generic advice if your
> solution is the best one for your problem? Or do you actually need a
> query to do a specific job?
>
> In the latter case, please repost. I'd appreciate it if you'd post the
> table structure as a CREATE TABLE statement (including all constraints
> and properties - any irrelevant columns may be left out, though) and the
> sample data as INSERT statements. Also, post the output you'd like to
> get from the sameple data.
> Check www.aspfaq.com/5006 for some useful hints on how to post.
>
> If you're looking for generic advice on how to deal with hierarchies,
> then your best bet is to buy and read "Trees and Hierarchies in SQL" by
> Joe Celko. This book describes several ways to model a hierarchy in SQL,
> with their pros and cons.
>
> You could also google for "nested sets model" and "adjacency list model"
> to find information about two of the most common ways to represent a
> hierarchy.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>
.

Relevant Pages

  • Re: A tree of location and site names..
    ... >This is a tuff one not sure if it can be done with an SQL query, ... sample data as INSERT statements. ... If you're looking for generic advice on how to deal with hierarchies, ...
    (microsoft.public.sqlserver.mseq)
  • Re: how would I store the XML
    ... Trees and hierarchies in SQL are fairly complex when it comes to ... So, unless you are using SQL Server 2005, I recommend storing the Xml ... Trees in SQL: ...
    (microsoft.public.dotnet.xml)
  • Hierarchy as UP constraint
    ... book (Joe Celko's “Trees and hierarchies in SQL for smarties“) have been written about hierarchies and relational databases, mostly on how to implement hierarchies in tables. ... PNR has a special foreign key-like constraint, ... and in the container interpretation: ...
    (comp.databases.theory)
  • Re: Trying to implent (Joe Celkos) Nested Sets, but need more data columns
    ... Nested sets are just one of many ways to model such ... >things in SQL. ... If anyone using nonrelational features needs help, ... It's possible to model hierarchies to obtain all the benefits of your ...
    (microsoft.public.sqlserver.programming)
  • Re: Serious errors with Create view command
    ... subdepts, groups of subdepts make depts anmd groups of depts make Divisions ... division you need to supply the number of ALL the hierarchies above it as ... Using VFP9 your CREATE VIEW displays like this in the View Designer View SQL ... inventory.subdeptno, inventory.classno, inventory.istyl FROM inventory ...
    (microsoft.public.fox.helpwanted)