By using AND, you are telling SQL Server that you want to find all uAccountMovement rows that do not exist in either of the other 2 tables. If you...

That's a pretty open question. You've obviously posted it because you feel there is a problem. Why don't you give us a description of what you think the...

When checking for the non-existance of outer joined rows, use the IS NULL comparison instead of the <> (not equals) comparison. The example SQL_ORACLE has given is correct. ...

Use Books Online to get an example. How can we write you a query if we don't know your table schema? Anything else would be an example derived...

I'm with Gail here folks. Why not find and fix the problem instead of masking it with NOLOCKs? If you are 100% OK with dirty reads, maybe consider...

I don't think that this will cause a deadlock. The SP will already have the rows locked and the update will happen to the new data page. I...

xp_cmdshell is disabled by default in SQL Server 2005. Have you enabled it? If not, go to the Surface Area Configuration tool>>Surface Area Configuration for Features and enable...

I would suggest running SQLDiag.exe the next time your system locks up.

Yes, having the clustered index on ColC would help. I would suggest dropping the second index on Col1 and recreating your PK as a non-clustered PK. You may...

I just wanted to thank you all for your military service.

Globally setting your isolation level to read uncommitted will prevent SELECTS from using shared locks; however, the side effect will be that you are allowing for dirty reads. I...

Jeff, that has got to be the best interview story ever told. I almost lost control of my bodily functions trying to contain the laughter!! You're my hero....

Not understanding cursors is a benefit to you! Matt has some great advice. Work the problem as if cursors do not exist. If you are going to...

No problem. Looking back today, I don't know what I was thinking with the <> join?? Oh well, I'm glad you've got it working. This one was...

Uh, I'm for hire. 🙂

Both Jeff and SQL Oracle are correct. This to me sounds like a good place for some VB script in DTS. ...