Home Forums SQL Server 7,2000 SQL Server Newbies Recursive query for a Bill of Materials table RE: Recursive query for a Bill of Materials table

  • October 31, 2007 at 2:48 am

    #746947

    Jeff Moden (10/31/2007)

    Close! Not seeing StockCode 12 anywhere in the result, though...

    SrockCode12 uses StockCode20.

    So it is not shown.

    I'm only displaying the lowest level item.