Home Forums SQL Server 2008 SQL Server 2008 - General SQL query to get all predecessors and successors for given node. RE: SQL query to get all predecessors and successors for given node.

  • September 3, 2012 at 8:06 pm

    #1533093

    sandhya.pingale (9/3/2012)

    How can i get the correct output without duplicate hierarchical records.

    Create a "Hierarchical Path" column and check to make sure the next recursion isn't going to already appear in the "Hieracrical Path" column. It's the same "trick" used to find all paths from one node to another in a node net or undirected cyclic graph.

    --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)