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

Bruen, Bruce Bruce.Bruen at railcorp.nsw.gov.au
Tue Jul 19 18:16:05 CDT 2005


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
 
 
This e-mail and any attachments may contain confidential information that is intended solely for the use of the intended recipient and may be subject to copyright. If you receive this e-mail in error, please notify the sender immediately and delete the e-mail and its attachments from your system.  You must not disclose, copy or use any part of this e-mail if you are not the intended recipient.  Any opinion expressed in this e-mail and any attachments is not an opinion of RailCorp unless stated or apparent from its content. RailCorp is not responsible for any unauthorised alterations to this e-mail or any attachments. RailCorp will not incur any liability resulting directly or indirectly as a result of the recipient accessing any of the attached files that may contain a virus.



More information about the AccessD mailing list