[AccessD] the dreaded n-recursive parts explosion (BOM) query... again

MartyConnelly martyconnelly at shaw.ca
Tue Jul 19 18:49:05 CDT 2005


Do you mean the nested set solution from Joe Celko
It is further written up in his book "SQL for Smarties"
http://www.mvps.org/access/queries/qry0023.htm
or this one
http://www.mvps.org/access/modules/mdl0027.htm

Bruen, Bruce wrote:

>Hi folks,
> 
>I thought I had got over this one years ago and can't find the SQL query
>template someone (Lembit???) here kindly supplied last time.  
> 
>But it has come back to get me again, so....
> 
>Does someone have a "template" query to return all the parts in an
>n-level parts explosion, preferably in binary-tree pre-order order.
>* all components, subcomponents and parts are held in the same table, 
>* it is a one way tree - i.e. parts that are used in multiple assemblies
>appear multiple times in the table (i.e.i.e. the pkey for the tree table
>is not the SKU)
> 
> 
>tia
>bruce
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list