--spid = 180 

--inner 
<?query --
UPDATE LEAD_MATCH_REQUEST_BATCH SET MATCH_SYNCH_STATUS = @P0, RETRY_COUNT = @P1 WHERE IN_EMAIL = @P2 AND BATCH_ID = @P3 AND REQUEST_ID = @P4
--?>

--outer 
<?query --
(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000))UPDATE LEAD_MATCH_REQUEST_BATCH SET MATCH_SYNCH_STATUS = @P0, RETRY_COUNT = @P1 WHERE IN_EMAIL = @P2 AND BATCH_ID = @P3 AND REQUEST_ID = @P4                                        
--?>



--locks 
<Database name="CMX_ORS">
  <Locks>
    <Lock request_mode="S" request_status="GRANT" request_count="1" />
  </Locks>
  <Objects>
    <Object name="LEAD_MATCH_REQUEST_BATCH" schema_name="dbo">
      <Locks>
        <Lock resource_type="OBJECT" request_mode="IX" request_status="WAIT" request_count="1" />
      </Locks>
    </Object>
  </Objects>
</Database>