Home Forums SQL Server 2008 T-SQL (SS2K8) problem in logic for finding a Recursive Cte RE: problem in logic for finding a Recursive Cte

  • May 4, 2014 at 7:43 pm

    #1710611

    thava (5/4/2014)

    Yes I know it, that's why I try to cleansing it, do you have any idea how to do it using TSQL

    You haven't really identified what this "Net" is for. It may very well be that it was never meant to be a classic "Adjacency List" where each child ID is unique and the list is acyclic. It may be the totally wrong thing to do to "clean it".

    What does this list of relational nodes actually represent?

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