thanks very much;

may i ask a follow up?

is the decision whether 1) only the (almost) final state or 2) each intervening state being part of the article determined by the...

We decided that because there was no containership expressed by the BETOS scheme, it was not worth the effort of coding the rows to show their lefts and rights.

Instead, we...

thanks very much

i just did, and it seems to be exactly the right model for this; as you observed, updates are rare, the levels are static, and the overhead...

After this level, there exist groups of CPT codes that are gathered under each lookupid...these are varying in number, e.g. there are 20 tests but 44 surgical procedures, so the...

my entry point is the part of the BOL hierarchyid data type tutorial where you copy five or six columns out of the employee table that exercise the reflexive relationship...

i mean that the values in lookup id should also be used in key id, as analogous to employee id being used as manager id.

by stuffing the values, i...

forgive me, should have looked there first.

but i thought it was plain as day....

thanks very much

drew

hi.

the way it works here is to frame your question like this;

For better, quicker answers on T-SQL questions, click on the following...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

i can assure you that if...

that looks really wonderful...thanks a ton

i will work on it today

drew

try substituting your table name for t1 in the example, and your column names too, and then run the code.

hth

drew

hi

this is not my work, but maybe it will turn the light on for you...it comes from here, and i keep it around for an example.

http://msmvps.com/blogs/robfarley/archive/2007/04/08/coalesce-is-not-the-answer-to-string-concatentation-in-t-sql.aspx

ps. i will...

Thanks very much, i really appreciate it.

drew

breath taking!

thanks a ton

drew

Thanks very much for explaining it to me, and for opening up the other considerations too; I have a lot to learn myself.

using what you showed me, i was able to finish that piece of code, but if it gets any gnarlier ill be back. I cannot thank you enough for what...