<deadlock-list><deadlock victim="processaac49b8"><process-list><process id="process600868" taskpriority="0" logused="516" waitresource="KEY: 815:1438969838829568 (2200564780d4)" waittime="3010" ownerId="2052797617" transactionname="UPDATE" lasttranstarted="2012-11-12T09:44:14.633" XDES="0x9e2df5170" lockMode="U" schedulerid="5" kpid="8056" status="suspended" spid="88" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2012-11-12T09:44:12.303" lastbatchcompleted="2012-11-12T09:44:12.303" clientapp=".Net SqlClient Data Provider" hostname="KPROD-API01" hostpid="2864" loginname="dev" isolationlevel="read committed (2)" xactid="2052797617" currentdb="815" lockTimeout="4294967295" clientoption1="673316896" clientoption2="128056"><executionStack><frame procname="superbill_8647_prod.dbo.tr_IU_Patient_ChangeTime" line="20" stmtstart="1136" stmtend="1422" sqlhandle="0x03002f03f90a702aee0870017f9d00000000000000000000">
UPDATE P
			SET DOB =  dbo.fn_ReplaceTimeInDate(i.DOB)
		FROM dbo.Patient P INNER JOIN
			inserted i ON
				P.PatientID = i.PatientID     </frame><frame procname="superbill_8647_prod.dbo.PatientDataProvider_UpdatePatient" line="58" stmtstart="3208" stmtend="5998" sqlhandle="0x03002f039813de1694ce7a01fa9f00000100000000000000">
UPDATE	dbo.Patient
	SET	Prefix = @prefix,
		FirstName = @first_name,
		MiddleName = @middle_name,
		LastName = @last_name,
		Suffix = @suffix,
		AddressLine1 = @address_1,
		AddressLine2 = @address_2,
		City = @city,
		State = @state,
		Country = @country,
		ZipCode = @zip,
		Gender = @gender,
		MaritalStatus = @marital_status,
		HomePhone = @home_phone,
		HomePhoneExt = @home_phone_x,
		WorkPhone = @work_phone,
		WorkPhoneExt = @work_phone_x,
		DOB = @dob,
		SSN = @ssn,
		EmailAddress = RTRIM(LTRIM(@email)),
		SendEmailCorrespondence = @sendEmailCorrespondence,
		ResponsibleDifferentThanPatient = @guarantor_different,
		EmploymentStatus = @employment_status,
		ReferringPhysicianID = @referrer_id,
		PrimaryProviderID = @primary_provider_id,
		PatientReferralSourceID = @patient_referral_source_id,
		DefaultServiceLocationID = @patient_default_location_id,
		EmployerID = @employer_id,
		MedicalRecordNumber = @medical_record_number,
		MobilePhone = @mobile_phone,
		MobilePhoneExt =     </frame><frame procname="superbill_8647_prod.dbo.WebServiceDataProvider_UpdatePatient" line="1715" stmtstart="176350" stmtend="178234" sqlhandle="0x03002f0327118b1de1d17a01fa9f00000100000000000000">
EXEC dbo.PatientDataProvider_UpdatePatient @PatientID, @PatientPrefix,
            @PatientFirstName, @PatientMiddleName, @PatientLastName,
            @PatientSuffix, @PatientAddressLine1, @PatientAddressLine2,
            @PatientCity, @PatientState, @PatientCountry, @PatientZipCode,
            @PatientGender, @PatientMaritalStatus, @PatientHomePhone,
            @PatientHomePhoneExt, @PatientWorkPhone, @PatientWorkPhoneExt,
            @PatientDateOfBirth, @PatientSSN, @PatientEmail,
            @PatientEmailCorrespondence, @GuarantorDifferentThanPatient,
            @EmploymentStatus, @ReferringProviderID,
            @DefaultRenderingProviderID, @PatientReferralSourceID, @LocationID,
            @EmployerID, @PatientMedicalRecordNumber, @PatientMobilePhone,
            @PatientMobilePhoneExt, @PrimaryCarePhysicianID, @userId, @active,
            0, @EmergencyName, @EmergencyPhone, @EmergencyPhoneExt     </frame></executionStack><inputbuf>
Proc [Database Id = 815 Object Id = 495653159]    </inputbuf></process><process id="processaac49b8" taskpriority="0" logused="0" waitresource="KEY: 815:313069931986944 (2300bd474c5c)" waittime="3026" ownerId="2052797637" transactionname="SELECT" lasttranstarted="2012-11-12T09:44:14.643" XDES="0xd98f2ebf8" lockMode="U" schedulerid="8" kpid="3740" status="suspended" spid="96" sbid="0" ecid="0" priority="0" transcount="0" lastbatchstarted="2012-11-12T09:44:12.303" lastbatchcompleted="2012-11-12T09:44:12.303" clientapp=".Net SqlClient Data Provider" hostname="KPROD-API01" hostpid="2864" loginname="dev" isolationlevel="read committed (2)" xactid="2052797637" currentdb="815" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056"><executionStack><frame procname="superbill_8647_prod.dbo.WebServiceDataProvider_UpdatePatient" line="1639" stmtstart="165698" stmtend="176348" sqlhandle="0x03002f0327118b1de1d17a01fa9f00000100000000000000">
SELECT  @PatientPrefix = COALESCE(@PatientPrefix, Prefix) ,
                @PatientFirstName = COALESCE(@PatientFirstName, FirstName) ,
                @PatientMiddleName = COALESCE(@PatientMiddleName, MiddleName) ,
                @PatientLastName = COALESCE(@PatientLastName, LastName) ,
                @PatientSuffix = COALESCE(@PatientSuffix, Suffix) ,
                @PatientAddressLine1 = COALESCE(@PatientAddressLine1,
                                                AddressLine1) ,
                @PatientAddressLine2 = COALESCE(@PatientAddressLine2,
                                                AddressLine2) ,
                @PatientCity = COALESCE(@PatientCity, City) ,
                @PatientState = COALESCE(@PatientState, State) ,
                @PatientCountry = COALESCE(@PatientCountry, Country) ,
                @PatientZipCode = COALESCE(@PatientZipCode, ZipCode) ,
                @PatientGender = CASE WHEN @PatientGender IS NULL THEN Gender     </frame></executionStack><inputbuf>
Proc [Database Id = 815 Object Id = 495653159]    </inputbuf></process></process-list><resource-list><keylock hobtid="313069931986944" dbid="815" objectname="superbill_8647_prod.dbo.Patient" indexname="CI_Patient_PracticeID_PatientID" id="lock8fd58fd00" mode="X" associatedObjectId="313069931986944"><owner-list><owner id="process600868" mode="X"/></owner-list><waiter-list><waiter id="processaac49b8" mode="U" requestType="wait"/></waiter-list></keylock><keylock hobtid="1438969838829568" dbid="815" objectname="superbill_8647_prod.dbo.Patient" indexname="PK_Patient" id="lockddf593000" mode="U" associatedObjectId="1438969838829568"><owner-list><owner id="processaac49b8" mode="U"/></owner-list><waiter-list><waiter id="process600868" mode="U" requestType="wait"/></waiter-list></keylock></resource-list></deadlock></deadlock-list>