The product is liquid...

The tables in this database have had the pagelock disabled with code like this:

EXEC sp_indexoption N'InventoryTran', N'disallowpagelocks', TRUE;

because users were blocking each other when they were updating different rows that...

I find no READ hints in the stored procedure, though it does INSERT and/or DELETE rows in InventoryTran just prior to the offending code I posted earlier. The error...

Sorry, I am not able to post the deadlock graph. I was not running the profiler when the deadlock occurred and I am not able to re-create it on...

Here are the 2 plan files attached

Ok. Well, I can't get an Actual exection plan on the If Exists or If Count > 0 because the code never completes, so here is the Estimated plan...

You want the xml plan?

When I save the graphical plans as .sqlplan files, they still look like the text plans. Without doing a screen print, I'm not sure how to capture the graphical...

if (select count(LotIngrLotKey) from va_negingrs) > 0

print 'exists'

Returns this plan:

StmtText

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

|--Compute Scalar(DEFINE:([Expr1032]=CASE WHEN [Expr1033] THEN (1) ELSE (0) END))

|--Nested Loops(Left Semi Join,...

I would agree with you, except that I ran this:

IF (SELECT COUNT(myColumn) FROM myView) > 0

PRINT 'EXISTS'

and I waited several minutes before I gave up. I can't explain it.

Thanks for the suggestion. I tried checking the count but still got no results. The code that I'm now using:

IF 0 NOT IN (SELECT ISNULL(LotIngrLotKey,0) FROM va_negingrs) ...

I was able to resolve my problem by replacing the IF EXISTS with an IN statement. Apparently the exection plan is generally more efficient for IN than IF EXISTS,...

Thanks. I guess I was making it more complicated that it needed to be.

I added this code to determine if I'm already inside a transaction so I don't try to begin another:

/*******************************************************************************************

*MANAGE NESTED TRANSACTIONS - DETERMINE WHERE TRANSACTION WAS STARTED

*******************************************************************************************

IF @@TRANCOUNT =...

UPDATE:

I was able to correct the condition that caused the error by using the method described in this discussion: http://www.developer.com/db/article.php/10920_3768671_1/TIP-Nested-Stored-Procedure-Calls-with-SQL-Server-Transactions.htm

As I suspected, the error had to do...