Two Useful Hierarchy Functions

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  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)