The odd thing is I had no problem setting this up in production. I only had a problem when I tried to modify it for a new release.

Using an ActiveX...

1. We would have loved to have implemented this as 3-tier, but had essentially a fixed budget and too much work for the money we had to include writing an...

Thanks all for the suggestions.

I can't set a server-wide limit since there are multiple instances (big cluster) and it would affect other apps that might have valid long-running queries.

Checking the...

I made sure that the Tree has no orphans. Every node in the tree has a parent (execpt the top one) and that parent exists as a node in the...

When you say "error in your data" do you mean things like an orphan (no supervisor) or a supervisor ID that isn't in the #tree?

That might explain things. I can...

Joe, your code had the same results as Jeff's. Here's the first 12 rows of 279 in my Stack. The Rights don't appear to correspond to the model. The first...

Thanks Joe,

The problem is in changing the code for converting an adjacency model to a nested set model from SQL/PSM to MS TSQL. There are several constructs in your code that don't...

I was looking at the "pop" code and trying to figure out what it was doing. Shouldn't the RightBower for any entry without subordinates be LeftBower+1? Shouldn't the RightBower for...

There are no dupes in Employees or Directory. The ID is our corporate Employee ID, there can only be one. It is the Primary Key in both tables.

The "Status<>2"...

Actually I didn't have to change much. Took out the Salary piece of the tables and loaded the #Personnel from my database's Employees table. Other than that it should be...

Jeff,

I'm getting some odd results when I really digest the output from this. According to Joe's model:

Albert's LeftBower is 1 and his RightBower is 1 more...

Looks like that did the trick!

Thanks!!!

Does anyone have a good translation of Joe's code from the link above? I tried pulling it into QA and updating it. Since I don't quite follow the concepts I'm...

Actually that was quicker than I expected!! THanks!!!

"Filtdump"?