Good idea... in fact, that's exactly what my code does... but there's nothing in the data to determine what level a node is at... just the parent ID, etc... and...

Perfect... thanks for the feedback, Shaun.

To keep conflicts with the Left and Right keywords to a minimum, I use LeftBower and RightBower in my code. A "bower" is one...

He has code that inserts and increases the left and right indicies... most of my code is batch code so I just recalc the whole tree from the adjacency model.

Heh... yeah... the good stuff never changes 😀

You bet...

http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html

If memory serves, the code that creates the nested model has a minor error in it... it leaves...

berto (1/9/2008)

---

Don't you see guys that approach: I wait for problems and then apply a patch is very bad. On systems which have very strict SLAs 99,999 for example you...

Actually, I believe the whole "adjacency model" thingy...

Stewart Joslyn (1/9/2008)

---

Is the truncation in Query Analyser or your app? If the former, check the Query Analyser setting in Tools/Options/Results tab/Max characters per column.

If you are returning a...

GilaMonster (1/8/2008)

---

It's a .net object that acts as a link between the connection and a data set. The adaptor gets told what the select, update, insert and delete

statements for...

If memory serves correctly, I believe the numerics at the end of the temp table are just a timestamp datatype. Not sure why you would consider them to be...

I gave you the code example that demonstrates how to determine if it was correctly entered to the nearest tenth of an hour... heh... didn't intend to write your whole...

JohnG (1/8/2008)

---

Definately NOT true. Oracle stores two digits per byte (plus an overhead byte or two for sign, etc.) in a varying storage model. Equivalent to the new...

Then, I don't know...

sp_SpaceUsed may not tell the whole story unless you include a second parameter... see BOL for more info but here's the basic syntax...

Syntax

sp_spaceused [[@objname =] 'objname']

...

Well..... kinda... DBCC INDEXDEFRAG will report back once every 5 minutes with a % complete... so you could start a run and get the % complete... the math is pretty...