Viewing 3 posts - 1 through 3 (of 3 total)
SELECT a.Col + b.Col
FROM Table a JOIN Table b ON a.Col < b.Col
UNION
FROM Table a JOIN Table b ON a.Col = b.Col
March 12, 2004 at 11:20 pm
#498659
In my opinion, adding two another columns is a better option,but it will need extra maintenance efforts. If the tree structure is changed frequently, keeping the table simple is better.
You...
March 4, 2004 at 6:48 pm
#497443
Disable the page lock through sp_indexoption.
March 4, 2004 at 5:57 pm
#497440