Post reply

Recursive query for a Bill of Materials table

  • June 6, 2013 at 11:58 am

    #1621863

    I have a working BOM recursive CTE, much like this one, but now I need to be able to input the part number I need the BOM from and have no clue how to do it.

    If I put in a where clause right after the first part of the CTE with a specific part number it will give me the results I need but I need to be able to tell the database which part number I need the BOM from easily.

    Any ideas on how to achieve this?

Viewing post 46 (of 45 total)

You must be logged in to reply to this topic. Login to reply