So this seems to me to mean that the dependencies thing is undependable and therefore, basically useless.

???!!!???

Is there a better (ie, dependable) way to see dependencies in SQL server?...

Thanks Grasshopper, removing from the subselect did the trick. Although I'm going to have to stare at it for awhile to understand why.

Yeah, I think you're right....

I may yet go with the calendar table idea. However, the rules for determining manfacturing month seem to be fairly clear:

Manufacturing year is divided into four 13-week quarters.

Manufacturing months...

Ok, I'll attempt to explain why. My function fnMfgMonth calculates the "manufacturing month" for a given date. "Manufacturing month" is determined by the week # of the year, and the...

So, I'm just curious to know why the "in" statement works in one version and not the other. I can't see anything in the definition of the case statement that...

Thanks. At this point this is enough to convince me that I don't need regular expressions that badly.

I don't recall turning identity_insert on for this table in the past, but there are lots of things I don't recall....:rolleyes:

That's probably what happened.

Is there a way to determine...

No, I don't think that's the issue. If I simply turn off the IDENTITY specification on the PK, but leave it as a unique PK, I can do the insert...

Thanks,

I found that I must remove the "As VSC" to get this to work.

Also found out that just putting parentheses around my original select statement works:

set @i=(SELECT TOP 1

Convert(int,Replace([ref...

Thanks for the info.

I have a bunch of pretty complex Access db's I've developed and maintained over the past 15 years or so. I'm about halfway through changing over...

Lamprey13, thanks. One question: What good does it do to have a try--catch block where the catch block does nothing? How is this different from just doing the "log...

GSquared, yes, that helps. Thanks!

"Much harder to document" than what??? I am struggling with the best method of error handling for transactions. If there's a clearer way, I'd really appreciate an example.

But my point is, to clarify, that it does fail on the PK violation and jump to the Catch, but xact_state is still =1. I have changed this now to...