The below is the second update statement,   it was cutoff in deadlock graph but got it from front end trace file
USE [MI_AC];
UPDATE MasterItinerary SET RecordLocator=&apos;RKSIMR&apos;,SysUser=&apos;ac2uAgency&apos;,Agency=&apos;0000000&apos;,Pcc=&apos;A001&apos;,Status=&apos;A&apos;,Modified=&apos;2017-04-25T06:33:02&apos;,LastDate=&apos;2017-05-25&apos;,StartDate=&apos;2017-05-22&apos;,AppModified=&apos;&apos;,Pos=&apos;YOW&apos;,PosCountry=&apos;CA&apos;,Origin=&apos;YYZ&apos;,Destination=&apos;RDU&apos;,NumberInParty=&apos;1&apos;,pnrtext=&apos;&lt;MasterItinerary&gt;&lt;SourceRefs&gt;&lt;source ref=&quot;RKSIMR&quot; name=&quot;AC&quot;&gt;&lt;PNRViewRS&gt;&lt;PNRIdentification TicketIssued=&quot;Y&quot; QueueRetrieved=&quot;N&quot; FareDataExists=&quot;Y&quot;&gt;&lt;RecordLocator&gt;RKSIMR&lt;/RecordLocator&gt;&lt;CreationDate&gt;2017-04-04&lt;/CreationDate&gt;&lt;CreationTime&gt;15:23&lt;/CreationTime&gt;&lt;Ownership&gt;&lt;CRSID&gt;AirCanada&lt;/CRSID&gt;&lt;Agency&gt;0000000&lt;/Agency&gt;&lt;PseudoCityCode&gt;A001&lt;/PseudoCityCode&gt;&lt;/Ownership&gt;&lt;AgencyData&gt;&lt;SignOn&gt;ACO&lt;/SignOn&gt;&lt;DutyCode&gt;GUEST&lt;/DutyCode&gt;&lt;IATA&gt;0000000&lt;/IATA&gt;&lt;AgencyName&gt;ac2u agency&lt;/AgencyName&gt;&lt;/AgencyData&gt;&lt;BookingOfficeID&gt;ACMOBILEBOOKING&lt;/BookingOfficeID&gt;&lt;TicketNumber TktType=&quot;E&quot;&gt;0142175981839&lt;/TicketNumber&gt;&lt;TicketInfo Source=&quot;AC&quot;&gt;&lt;TicketNumber TktType=&quot;E&quot;&gt;0142175981839&lt;/TicketNumber&gt;&lt;SegmentElementNumber&gt;1&lt;/SegmentElementNumber&gt;&lt;SedmnCategory="R">ACMobileBooking-XXXXac3f</Text></History></PNRViewRS></source></SourceRefs></MasterItinerary>'
WHERE uniqueID=9215532;