Home Forums SQL Server 2008 T-SQL (SS2K8) How to compare parent child data in SQL RE: How to compare parent child data in SQL

  • February 27, 2013 at 8:47 pm

    #1591831

    dwain.c (2/27/2013)

    However I think it may be a bit overkill in this case where all you need to do is sum the children of a parent to one level deep (assuming this is right).

    If that's all they'll EVER want to do, then I agree. While it’s true that I tend to “over” plan by making such "simple" things bullet proof to scope changes, scale changes, and future requirements, let's hope that the complexity of the doubly-linked (each row has the parent and child listed) hierarchical Adjacency List in T1 isn't the foreboding of more complex requests that I think it will be.

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