Here is the deadlock info from the SQL log, unfirttunaltey it includes both deadlock flags. Due to my monitoring software
Date,Source,Severity,Message
03/25/2013 10:35:35,spid34s,Unknown,waiter id=processd4d708
03/25/2013 10:35:35,spid34s,Unknown,waiter-list
03/25/2013 10:35:35,spid34s,Unknown,owner id=process4fa0508
03/25/2013 10:35:35,spid34s,Unknown,owner-list
03/25/2013 10:35:35,spid34s,Unknown,exchangeEvent id=Pipe155556480 WaitType=e_waitPipeGetRow nodeId=3
03/25/2013 10:35:35,spid34s,Unknown,waiter id=process689b88 mode=IX requestType=wait
03/25/2013 10:35:35,spid34s,Unknown,waiter-list
03/25/2013 10:35:35,spid34s,Unknown,owner id=processd4d708 mode=S
03/25/2013 10:35:35,spid34s,Unknown,owner-list
03/25/2013 10:35:35,spid34s,Unknown,pagelock fileid=1 pageid=4013239 dbid=9 objectname=DBXXXX.dbo.orderha id=lock22ca4f380 mode=S associatedObjectId=72057609113042944
03/25/2013 10:35:35,spid34s,Unknown,waiter id=process4fa0508 mode=S requestType=wait
03/25/2013 10:35:35,spid34s,Unknown,waiter-list
03/25/2013 10:35:35,spid34s,Unknown,owner id=process689b88 mode=X
03/25/2013 10:35:35,spid34s,Unknown,owner-list
03/25/2013 10:35:35,spid34s,Unknown,keylock hobtid=72057602492792832 dbid=9 objectname=DBXXXX.dbo.orderha indexname =PK_orderhaid=lock2e17cd700 mode=X associatedObjectId=72057602492792832
03/25/2013 10:35:35,spid34s,Unknown,resource-list
03/25/2013 10:35:35,spid34s,Unknown,Select isnull(count(rsn)<c/>0) as value from orderha where status < 3 and <nl/>exists (select rsn from printbatches where shippingloc in ('GWM'<c/>'GWHUBM') and batch=orderha.printref)
03/25/2013 10:35:35,spid34s,Unknown,inputbuf
03/25/2013 10:35:35,spid34s,Unknown,Select isnull(count(rsn)<c/>0) as value from orderha where status < 3 and <nl/>exists (select rsn from printbatches where shippingloc in ('GWM'<c/>'GWHUBM') and batch=orderha.printref)
03/25/2013 10:35:35,spid34s,Unknown,frame procname=adhoc line=1 sqlhandle=0x02000000b124a93432a05dac02c98dd52c4bc4a8623e4c71
03/25/2013 10:35:35,spid34s,Unknown,executionStack
03/25/2013 10:35:35,spid34s,Unknown,process id=processd4d708 taskpriority=0 logused=10000 waittime=2656 schedulerid=3 kpid=2888 status=suspended spid=52 sbid=0 ecid=0 priority=0 trancount=0 lastbatchstarted=2013-03-25T10:35:33.040 lastbatchcompleted=2013-03-25T10:35:33.040 clientapp=PHP 5 hostname=fuweb03 hostpid=227446 loginname=fusqldbuser isolationlevel=read committed (2) xactid=37813851141 currentdb=9 lockTimeout=4294967295
03/25/2013 10:35:35,spid34s,Unknown,update orderha set shipped=1<c/>status=3<c/>shipdate=getdate() where sessionid='FN7592810' and orderha=1
03/25/2013 10:35:35,spid34s,Unknown,inputbuf
03/25/2013 10:35:35,spid34s,Unknown,update orderha set shipped=1<c/>status=3<c/>shipdate=getdate() where sessionid='FN7592810' and orderha=1
03/25/2013 10:35:35,spid34s,Unknown,frame procname=adhoc line=1 sqlhandle=0x0200000003349709cef9f8e441641eabcec39ed43894f7ae
03/25/2013 10:35:35,spid34s,Unknown,(@1 int<c/>@2 int<c/>@3 varchar(8000)<c/>@4 tinyint)UPDATE [orderha] set [shipped] = @1<c/>[status] = @2<c/>[shipdate] = getdate() WHERE [sessionid]%%=%%@3 AND [orderha]%%=%%@4
03/25/2013 10:35:35,spid34s,Unknown,frame procname=adhoc line=1 sqlhandle=0x020000006d90e92510cd4c7f9a9af4c3c7d68bb4cd95914a
03/25/2013 10:35:35,spid34s,Unknown,executionStack
03/25/2013 10:35:35,spid34s,Unknown,process id=process689b88 taskpriority=0 logused=292 waitresource=PAGE: 9:1:4013239 waittime=2809 ownerId=37813851204 transactionname=UPDATE lasttranstarted=2013-03-25T10:35:33.113 XDES=0x148857970 lockMode=IX schedulerid=1 kpid=6156 status=suspended spid=59 sbid=0 ecid=0 priority=0 trancount=2 lastbatchstarted=2013-03-25T10:35:33.107 lastbatchcompleted=2013-03-25T10:35:33.107 clientapp=PHP 5 hostname=fuweb03 hostpid=227446 loginname=fusqldbuser isolationlevel=read committed (2) xactid=37813851204 currentdb=9 lockTimeout=4294967295
03/25/2013 10:35:35,spid34s,Unknown,inputbuf
03/25/2013 10:35:35,spid34s,Unknown,Select isnull(count(rsn)<c/>0) as value from orderha where status < 3 and <nl/>exists (select rsn from printbatches where shippingloc in ('GWM'<c/>'GWHUBM') and batch=orderha.printref)
03/25/2013 10:35:35,spid34s,Unknown,frame procname=adhoc line=1 sqlhandle=0x02000000b124a93432a05dac02c98dd52c4bc4a8623e4c71
03/25/2013 10:35:35,spid34s,Unknown,executionStack
03/25/2013 10:35:35,spid34s,Unknown,process id=process4fa0508 taskpriority=0 logused=0 waitresource=KEY: 9:72057602492792832 (f9008448af4c) waittime=2709 ownerId=37813851141 transactionname=SELECT lasttranstarted=2013-03-25T10:35:33.080 XDES=0x1b7502b60 lockMode=S schedulerid=14 kpid=236 status=suspended spid=52 sbid=0 ecid=13 priority=0 trancount=0 lastbatchstarted=2013-03-25T10:35:33.040 lastbatchcompleted=2013-03-25T10:35:33.040 clientapp=PHP 5 hostname=fuweb03 hostpid=227446 isolationlevel=read committed (2) xactid=37813851141 currentdb=9 lockTimeout=4294967295
03/25/2013 10:35:35,spid34s,Unknown,process-list
03/25/2013 10:35:35,spid34s,Unknown,deadlock victim=process4fa0508
03/25/2013 10:35:35,spid34s,Unknown,deadlock-list
03/25/2013 10:35:35,spid5s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x00000001B7502B60 Mode: S SPID:52 BatchID:0 ECID:13 TaskProxy:(0x00000001243D7BD0) Value:0xb6996cc0 Cost:(0/0)
03/25/2013 10:35:35,spid5s,Unknown,Victim Resource Owner:
03/25/2013 10:35:35,spid5s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
03/25/2013 10:35:35,spid5s,Unknown,ResType:ExchangeId Stype:'AND' SPID:52 BatchID:0 ECID:0 TaskProxy:(0x000000023373C510) Value:0xd4d708 Cost:(0/10000)
03/25/2013 10:35:35,spid5s,Unknown,Port: 0x0000000155556480 Xid Slot: 0<c/> Wait Slot: -1<c/> Task: 0x0000000000D4D708<c/> (Coordinator)<c/> Exchange Wait Type: e_waitPipeGetRow<c/> Merging: 0
03/25/2013 10:35:35,spid5s,Unknown,Node:3
03/25/2013 10:35:35,spid5s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
03/25/2013 10:35:35,spid5s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x0000000148857970 Mode: IX SPID:59 BatchID:0 ECID:0 TaskProxy:(0x000000014A4F0538) Value:0xcf1395c0 Cost:(0/292)
03/25/2013 10:35:35,spid5s,Unknown,Requested by:
03/25/2013 10:35:35,spid5s,Unknown,Input Buf: Language Event: Select isnull(count(rsn)<c/>0) as value from orderha where status < 3 and <nl/>exists (select rsn from printbatches where shippingloc in ('GWM'<c/>'GWHUBM') and batch=orderha.printref)
03/25/2013 10:35:35,spid5s,Unknown,SPID: 52 ECID: 0 Statement Type: SELECT Line #: 1
03/25/2013 10:35:35,spid5s,Unknown,Owner:0x0000000224960B80 Mode: S Flg:0x40 Ref:0 Life:00000001 SPID:52 ECID:0 XactLockInfo: 0x00000000800A5940
03/25/2013 10:35:35,spid5s,Unknown,Grant List 0:
03/25/2013 10:35:35,spid5s,Unknown,PAGE: 9:1:4013239 CleanCnt:2 Mode:S Flags: 0x3
03/25/2013 10:35:35,spid5s,Unknown,Node:2
03/25/2013 10:35:35,spid5s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
03/25/2013 10:35:35,spid5s,Unknown,ResType:LockOwner Stype:'OR'Xdes:0x00000001B7502B60 Mode: S SPID:52 BatchID:0 ECID:13 TaskProxy:(0x00000001243D7BD0) Value:0xb6996cc0 Cost:(0/0)
03/25/2013 10:35:35,spid5s,Unknown,Requested by:
03/25/2013 10:35:35,spid5s,Unknown,Input Buf: Language Event: update orderha set shipped=1<c/>status=3<c/>shipdate=getdate() where sessionid='FN7592810' and orderha=1
03/25/2013 10:35:35,spid5s,Unknown,SPID: 59 ECID: 0 Statement Type: UPDATE Line #: 1
03/25/2013 10:35:35,spid5s,Unknown,Owner:0x00000001D6758340 Mode: X Flg:0x40 Ref:1 Life:02000000 SPID:59 ECID:0 XactLockInfo: 0x00000001488579B0
03/25/2013 10:35:35,spid5s,Unknown,Grant List 0:
03/25/2013 10:35:35,spid5s,Unknown,KEY: 9:72057602492792832 (f9008448af4c) CleanCnt:2 Mode:X Flags: 0x1
03/25/2013 10:35:35,spid5s,Unknown,Node:1
03/25/2013 10:35:35,spid5s,Unknown,Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:
03/25/2013 10:35:35,spid5s,Unknown,Wait-for graph
03/25/2013 10:35:35,spid5s,Unknown,Deadlock encountered .... Printing deadlock information