--spid = 770

--inner query
<?query --
MERGE INTO [dbo].[LEAD_MATCH_REQUEST_BATCH] TGT
                     USING (SELECT * FROM [dbo].[LEAD_MATCH_REQUEST_BATCH]  BL with (nolock)
                                  WHERE NOT EXISTS (SELECT 1 FROM SERV_NOW_LEAD_MULTI_MATCH_TRACKER_DETAIL TD with (nolock)
                                                              WHERE BL.REQUEST_ID = TD.TRACKER_ID
                                                              AND TD.BATCH_ID = @batch_id)
                                  AND BL.BATCH_ID = @batch_id
                                  AND BL.IS_PROCESSED = 0) SRC
                     ON TGT.REQUEST_ID = SRC.REQUEST_ID AND TGT.BATCH_ID = SRC.BATCH_ID
                     WHEN MATCHED THEN UPDATE SET TGT.IS_PROCESSED = 1, TGT.COMPLETE_DATE = GETDATE(), TGT.OUT_MATCH_REASON_CD = 'No Match Found' ;
--?>

--outer query
<?query --
(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000),@P4 nvarchar(4000))DECLARE     @return_value int,
              @STATUS_CODE varchar(20),
              @STATUS_DESC varchar(4000)

EXEC   @return_value = [dbo].[sp_crm_lead_account_multi_match_filter]
              @batch_id = @P0,
              @isExternalMatch = @P1,
      
              @isDebug = @P2,
@isRealTime = @P3,
              @IN_SRC_SYSTEM = @P4,
              @STATUS_CODE = @STATUS_CODE OUTPUT,
              @STATUS_DESC = @STATUS_DESC OUTPUT

SELECT @STATUS_CODE as N'@STATUS_CODE',
              @STATUS_DESC as N'@STATUS_DESC'

SELECT 'Return Value' = @return_value                                        
--?>




--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>



<additional_info>
  <text_size>-1</text_size>
  <language>us_english</language>
  <date_format>mdy</date_format>
  <date_first>7</date_first>
  <quoted_identifier>ON</quoted_identifier>
  <arithabort>OFF</arithabort>
  <ansi_null_dflt_on>ON</ansi_null_dflt_on>
  <ansi_defaults>OFF</ansi_defaults>
  <ansi_warnings>ON</ansi_warnings>
  <ansi_padding>ON</ansi_padding>
  <ansi_nulls>ON</ansi_nulls>
  <concat_null_yields_null>ON</concat_null_yields_null>
  <transaction_isolation_level>ReadCommitted</transaction_isolation_level>
  <lock_timeout>-1</lock_timeout>
  <deadlock_priority>0</deadlock_priority>
  <row_count>1</row_count>
  <command_type>MERGE</command_type>
  <sql_handle>0x03000b00175a434e32b52701d3ae000001000000000000000000000000000000000000000000000000000000</sql_handle>
  <plan_handle>0x05000b00175a434e30bc3b3eb301000001000000000000000000000000000000000000000000000000000000</plan_handle>
  <statement_start_offset>9978</statement_start_offset>
  <statement_end_offset>11130</statement_end_offset>
  <host_process_id>0</host_process_id>
  <group_id>2</group_id>
  <original_login_name>cmx_ors</original_login_name>
</additional_info>