I think I've figured out at least part of the problem (maybe all of it). The UPDATE statement in my INSTEAD OF UPDATE trigger is not right. I'm...

I've managed to solve my own problem. It was easier than I thought, I've just never done anything like that before.

It amounts to;

CONTSTRAINT One_or_the_Other CHECK ((AAA IS NULL AND...

Hi kens.

That's an interesting idea. One I've modeled in UML but implemented in the simple way you've seen. You are correct. The data is hierarchical. Essentially,...

That was the answer I feared...

Now that I know that it's a product limitation and not something that I'm doing wrong I can deal with it. I'll probably use...

Hi. r.hensbergen

I've uploaded a script which will create the database and put some data in all of the tables for you to look at.

once you look at the data (in...

Hi Jeff.

For the sake of simplicity I used Jack's script which functionally does the same thing that I'm trying to do.

I substituted TABLOCK for TABLOCKX and still got;

Msg 308, Level...

Jack;

I think it must have to do with the difference between SQL 2000 and 2005 because I copied you code and pasted it into a window and tried to run...

Jack;

I do have a bit of a problem. When I use a separate create clustered index statement - I get an error (caused by the table hint of the...

Jack;

Well, I'll be! It works just as you said. That's awesome. Kind of befuddling but awesome none the less.

Now, where it appears I had no solution, I...

Thanks for this Jeffrey!

I'm using SQL 2000 right now. If I understand what you're saying then my update statement should look like this;

UPDATE ANS SET

@Depth = TopDepth = CASE...

That's very interesting. I'll try it.

Stay tuned... 🙂

For those interested in the code I'm working with...

The data represents measurements of reservoir attributes from oil (bitumen actually) wells. Each depth down the well bore has a set...

Matt. Thanks for the idea. I think it may work. I'll try it on Monday.

Jack. Thanks for your post.

I'm at home for the weekend now. I'll post some code on Monday.

The essence of it though is I'm testing for the exitance of...

Thanks for all of the feedback. I realize I should have provided a bit more detail. After I posted, I learned, by reading the help files that;

- I...