Re: Parts made up of parts made up of parts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Helpless wrote:
I know how hierarchies work

I apologize if I offended you. I assumed that someone who knew they had
a BOM or hierarchy on their hands would namecheck it.

I just don't know how to show them in Access

Asking how to model hierarchies in a SQL product is a bit beyond the
scope of a newsgroup thread, IMO. Why, the issues could fill a whole
book! Thankfully, there is such a book:

Joe Celko's Trees and Hierarchies in SQL for Smarties
http://www.amazon.com/gp/product/1558609202/

I read it a couple of weeks ago and highly recommend it. The author
clearly prefers a nested sets approach over the more commonly
encountered adjacency list approach (procedural and denormalized in
nature) yet still provides lots of useful routines for both.

Jamie.

--

.

Relevant Pages

  • Re: Recursive Queries?
    ... One of the hierarchical designs given in TREES & HIERARCHIES IN SQL ... because it ports and gives very easy hierarchical aggregations (BOM, ... accounting reports, etc as opposed to path searches). ... A sales line item is comparable with a production stock requirement ...
    (comp.databases.ms-sqlserver)
  • Re: Recursive Queries?
    ... One of the hierarchical designs given in TREES & HIERARCHIES IN SQL ... because it ports and gives very easy hierarchical aggregations (BOM, ... accounting reports, etc as opposed to path searches). ...
    (comp.databases.ms-sqlserver)
  • Re: Hierarchical Top Level BOM Query
    ... Get a copy of TREES & HIERARCHIES IN SQL. ... I worked out a BOM using the ... nested sets model. ...
    (microsoft.public.sqlserver.programming)