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

  • April 11, 2011 at 3:22 pm

    #1310136

    david.moule (4/11/2011)

    Using the BOL article on "Expanding Hierarchies"... I took the example code and modified it as below. My problem is that it needs the top level BOM in order to start the expansion, whereas I want the output from the expansion of all the top level BOM's in my list of BOM's....

    I take it you didn't actually read what I sent you, then.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)