cool

<deadlock-list>
 <deadlock victim="processc3eef8">
  <process-list>
   <process id="processc3eef8" taskpriority="0" logused="2316" waitresource="KEY: 11:72057603266445312 (bc003d4a6ac6)" waittime="1265" ownerId="227297079" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.780" XDES="0x96b89a50" lockMode="U" schedulerid="1" kpid="3216" status="suspended" spid="59" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:02:30.957" lastbatchcompleted="2013-03-27T09:02:24.097" clientapp="Microsoft SQL Server Management Studio - Query" hostname="blankedout" hostpid="3840"
   loginname="blankedout" isolationlevel="read committed (2)" xactid="227297079" currentdb="11" lockTimeout="4294967295" clientoption1="673319008" clientoption2="390200">
    <executionStack>
     <frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="51" stmtstart="2926" stmtend="3316" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
Update b set Draw_Date=d.draw_date
    from tableA b
    inner join tableB d with (nolock) on b.draw_no=d.draw_no
    and left(b.game,2)=&apos;UK&apos; and b.Draw_Date is null     </frame>
     <frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
insert into mem_node_payment(params here)
    values(params here)     </frame>
     <frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
exec SP_MEM_NODE_PAYMENT_INSERT params here     </frame>
     <frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
exec SP_NONE_PAYMENT params here</frame>
     <frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
exec SP_RECORD params here </frame>
     <frame procname="adhoc" line="6" stmtstart="112" stmtend="412" sqlhandle="0x0200000022524113d31d57be58017a1c0d1d6a11d3d433a3">
EXEC SP_CONFIRMED   @table_name = &apos;sys_transaction&apos; /* VARCHAR(50) */,
                            @pk_id = 1000568271 /* INT */,
                            @amt_ext = 5 /* MONEY */     </frame>
    </executionStack>
    <inputbuf>
DECLARE @I int
SET @I = 1

WHILE @I &lt;= 2000
BEGIN
    EXEC SP_CONFIRMED   @table_name = &apos;sys_transaction&apos; /* VARCHAR(50) */,
                            @pk_id = 1000568271 /* INT */,
                            @amt_ext = 5 /* MONEY */
    SET @I = @I + 1
END
    </inputbuf>
   </process>
   <process id="processecb198" taskpriority="0" logused="3148" waitresource="PAGE: 11:1:1554543" waittime="1156" ownerId="227297052" transactionname="user_transaction" lasttranstarted="2013-03-27T09:06:21.750" XDES="0x8b79c700" lockMode="U" schedulerid="3" kpid="604" status="suspended" spid="58" sbid="2" ecid="0" priority="0" transcount="2" lastbatchstarted="2013-03-27T09:06:21.750" lastbatchcompleted="2013-03-27T09:06:21.750" clientapp="EntityFrameworkMUE" hostname="hostgoeshere" hostpid="1908"
   loginname="blankedout" isolationlevel="read committed (2)" xactid="227297052" currentdb="11" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056">
    <executionStack>
     <frame procname="madeupdb.dbo.trgUpdateMadeUpName" line="91" stmtstart="6156" stmtend="6652" sqlhandle="0x03000b008eb92a797d4acd0072a100000000000000000000">
Update b set  syd_id=d.syd_id
    from tableA b
    inner join tableC d with (nolock) on b.syd_pers_id=d.syd_pers_id
    --and b.game=&apos;es_lotto&apos;
    and b.game=d.game  and isnull(b.syd_id,0)=0     </frame>
     <frame procname="madeupdb.dbo.SP_MEM_NODE_PAYMENT_INSERT" line="19" stmtstart="1006" stmtend="1560" sqlhandle="0x03000b00a3b8842785a31f01da9e00000100000000000000">
insert into mem_node_payment(params here)
    values(params here)     </frame>
     <frame procname="madeupdb.dbo.SP_NONE_PAYMENT" line="156" stmtstart="10248" stmtend="10554" sqlhandle="0x03000b002d916b7762853201f6a000000100000000000000">
exec SP_MEM_NODE_PAYMENT_INSERT params here</frame>
     <frame procname="madeupdb.dbo.SP_RECORD" line="65" stmtstart="5278" stmtend="5532" sqlhandle="0x03000b00dbcf071433b9510104a100000100000000000000">
exec SP_NONE_PAYMENT params here</frame>
     <frame procname="madeupdb.dbo.SP_CONFIRMED" line="62" stmtstart="3668" stmtend="3828" sqlhandle="0x03000b00c0a66d208b76a90017a100000100000000000000">
exec SP_RECORD params here </frame>
     <frame procname="adhoc" line="1" stmtstart="118" sqlhandle="0x01000b00b691f53320ccd91c010000000000000000000000">
EXEC sp_confirmed params here </frame>
     <frame procname="unknown" line="1" sqlhandle="0x000000000000000000000000000000000000000000000000">
unknown     </frame>
    </executionStack>
    <inputbuf>
(@table_name nvarchar(19),@pk_id int,@amt_ext decimal(5,4))EXEC sp_confirmed @table_name, @pk_id, @amt_ext    </inputbuf>
   </process>
  </process-list>
  <resource-list>
   <pagelock fileid="1" pageid="1554543" dbid="11" objectname="madeupdb.dbo.tableA" id="lock105e0b680" mode="IX" associatedObjectId="72057603266510848">
    <owner-list>
     <owner id="processc3eef8" mode="IX"/>
    </owner-list>
    <waiter-list>
     <waiter id="processecb198" mode="U" requestType="convert"/>
    </waiter-list>
   </pagelock>
   <keylock hobtid="72057603266445312" dbid="11" objectname="madeupdb.dbo.tableA" indexname="IX_tableA_Draw_Date" id="lock149f6cf00" mode="X" associatedObjectId="72057603266445312">
    <owner-list>
     <owner id="processecb198" mode="X"/>
    </owner-list>
    <waiter-list>
     <waiter id="processc3eef8" mode="U" requestType="wait"/>
    </waiter-list>
   </keylock>
  </resource-list>
 </deadlock>
</deadlock-list>