Home Forums Article Discussions Article Discussions by Author Discuss content posted by John Cawley III Two Useful Hierarchy Functions RE: Two Useful Hierarchy Functions

  • August 3, 2010 at 7:09 am

    #1201489

    Jack-408956 (8/3/2010)

    None of this "with" stuff is working for us on MSSQL 2000...

    Server: Msg 156, Level 15, State 1, Procedure subordinates, Line 2

    Incorrect syntax near the keyword 'with'.

    Is it a feature of MSSQL 2005 only?

    As a side bar, I'm writing an article/presentation on how to deal with Million Row Hierarchies... you just reminded me that there are still people out there that may need to do such a thing in MSSQL 2000 or earlier and that I need to include code for that in the presentation materials.

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