Home Forums SQL Server 2008 T-SQL (SS2K8) Hierarchy example - Ken Henderson's book - not working RE: Hierarchy example - Ken Henderson's book - not working

  • polkadot (3/3/2013)


    Well, if that's all it is, then great. I tend to overblame myself. I was sure it was me.

    Well, Joe Celko forewarded the book. I would have thought he would have caught it.

    Nah, not to worry... Overblaming yourself is actually a good thing. Those that do the opposite tend to fall in the arrogant category and that's when code really begins to suffer.

    I ran the code you provided and it's really odd to me. I cannot, for the life of me, figure out why Ken wanted to create six copies of the same hierarchy with all people at all levels reporting to the same supervisor.

    I agree with Lynn, as well. Just because someone forwards a book, doesn't mean they even looked at the content never mind actually doing any technical reviews. Even some authors don't check their own code and not all technical reviewers are good technical reviewers.

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