Points: 55309

7/11/2016 4:42:18 PM

BOM query

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

This one is worth the price of admission, if you've ever needed a BOM query

Here is my template query, it will work for BOM items nested no more than 6 deep, it uses nested cursors to accomplish the work.
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables