I realize that. DBCCs have been done and everything is back as it should be.

Thanks again for helping out. I really appreciate your input!

It was done in the context of legitimate administrative activates. Unfortunately, it had a negative impact due to state of the environment at the time. There were a...

LOL!

Problem solved (I believe). I was one of our own DBA's [name withheld].

Yes. In fact it was. Looks like the server was recovering from a hard reboot the two days previous however, the databases involved were working fine for...

Agreed. I am not sure why Sample B is cited as being a self-join as it does not join to itself! 😛

SELECT

T1.col1,

T1.col2,

T2.col3,

T2.col4

FROM

[MySelfJoinTableName] T1 JOIN [MySelfJoinTableName] T2 ON T1.FKColName = T2.PKColName

Run “exec sp_who” and see if your script to drop/recreate the constraint is being blocked by anyone (including yourself).

It is possible you left a transaction open accidently. You can...

I am not sure if I understand completely. I imagine that the categories you speak of are treated just like tree nodes, and that a node can NOT have...

The following represents an example of a self reference table hierarchy example. You can see that the sub items of the item marked as inactive are not displayed.

CREATE TABLE...

I would tend to agree. If you know how to use regular expressions, that would probably be a better solution. User defined functions tend to slow things down...

I ran into this a while back. I came up with a solution, but it is not the best. Create a function in the database that takes one...