Recursive CTE BAQ

[bordway (Bruce Ordway)]

@Rik

CTE to reference itself (the UNION ALL

You could try the search word indented…
The list returned should include a few threads that discuss the indenting of BOMs which might get you started.
e.g. here is one link:

Indented BOM SQL Query

So to go along with my post a couple of days ago about the Method Master, (Indented Bill of Operations - ERP 10 - Epicor User Help Forum) I’m trying to write my own SQL query for BOM Listing. It will be much cleaner and just provide me with the information I need versus the report. I have for the most part my multi level query written out and working properly except for one little thing. My where clause is currently around PartRev.Approved = true or null. This works great for probably 95% of th…