Thanks for the reply.

I'm not sure what you're saying. Am I reading you to say that cascading can only go to one table? That's not correct otherwise the...

After much gnashing and trashing I think I've got this solved. Here's the code for posterity sake. Maybe it'll help someone else some day.

-----------------------------------------------------------------------------------------------

-- GET STAFF_ID (User defined...

Hi.

I've tried to take a slightly different tack and am now having a different problem. I'm trying to use a function to perform a check constraint. Logically, I...

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...