1284 
Inner qry 

<?query --
WITH LEAD_CONTACT_EMAIL_MATCH AS (SELECT C.*, REL.CHILD_PARTY_ID, BL.IN_EMAIL, BL.REQUEST_ID 
                                                                                  FROM C_B_PARTY C with (nolock), C_B_PARTY_REL REL with (nolock), 
                                                                                  LEAD_MATCH_REQUEST_BATCH BL with (nolock)
                                                                                  WHERE C.PARTY_TYP_CD = 'Contact'
                                                                                  AND C.BO_CLASS_CODE = 'Individual'
                                                                                  AND C.HUB_STATE_IND = 1
                                                                                  AND C.ROWID_OBJECT = REL.PARENT_PARTY_ID
                                                                                  AND REL.HUB_STATE_IND = 1
                                                                                  AND EXISTS (SELECT 1 FROM C_B_PARTY_COMM COMM with (nolock)
                                                                                                       WHERE COMM.PARTY_ID = C.ROWID_OBJECT
                                                                                                       AND COMM.COMM_TYP_CD = 'EMAIL'
                                                                                                       AND COMM.HUB_STATE_IND = 1
                                                                                                       AND COMM.COMM_VAL = BL.IN_EMAIL
                                                                                                       )
                                                                                  AND NOT EXISTS (SELECT 1 FROM #ResultSet PREV_MTCH
                                                                                                              WHERE BL.REQUEST_ID = PREV_MTCH.REQUEST_ID
                                                                                                              )
                                                                                  AND BL.BATCH_ID = @batch_id
                                                                                  AND BL.IS_PROCESSED = 0
                                                                           )
                     INSERT #ResultSet
                     select BL.REQUEST_ID, P.ROWID_OBJECT, A.SURF_ID, A.WEBSITE, P.PARTY_NM, 
                              P.ADDR_LN1, P.ADDR_LN2, P.CITY, P.STATE_CD, --P.STATE_NM
                              P.COUNTRY_CD, P.POSTAL_CD, P.POSTAL_EXT_CD, P.MDM_ID, P.CMID, 
                              P.PARTY_TYP_CD, P.CREATE_DATE, A.SALES_REP, A.TERRITORY_ID,  
                             'ASSOCIATED_CONTACT_ACCOUNT' OUT_MATCH_REASON_CD, BL.IN_EMAIL
                     from C_B_PARTY P with (nolock), LEAD_CONTACT_EMAIL_MATCH BL with (nolock), C_B_ACCOUNT A with (nolock)
                     where P.BO_CLASS_CODE = 'Organization'
                     AND P.PARTY_TYP_CD in ('Customer', 'Customer - Subsidiary', 'Suspect', 'Prospect', 'Customer via Partner', 'Inactive', 'Inactive-Former Customer')
                     AND P.ACTV_FLG = '1'
                     AND P.HUB_STATE_IND = 1
                     AND A.HUB_STATE_IND = 1
                     AND A.IS_MERGED IS NULL
                     AND P.ROWID_OBJECT = BL.CHILD_PARTY_ID
                     AND P.ROWID_OBJECT = A.PARTY_ID
                     AND A.SP_END_CUSTOMER IS NULL
                     AND NOT EXISTS(select 1 from C_B_LU_SVC_PRVDR_STS STS
                                                WHERE STS.STATUS_CD = P.SERVICE_PROVIDER_STATUS
                                                AND STS.STATUS_CD in ('Managed Service Provider', 'Service Provider (registered)', 'Service Provider (unconfirmed)', 'MSP End Customer', 'MSP', 'Service Provider (denied/offboarded)')
                                                )
                     AND NOT EXISTS (SELECT 1 FROM C_B_TERRITORY TERR with (nolock)
                                                WHERE TERR.ROWID_OBJECT = A.TERRITORY_ID
                                                AND TERR.GEO_KEY LIKE '%MSP%'
                                                )
--?>


Outer qry 

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

EXEC   @return_value = [dbo].[sp_crm_lead_account_matching]
              @batch_id = @P0,
              @tracker_id = @P1,
        @isRealTime = @P2,
              @isDebug = @P3,
        @BATCH_ROWCOUNT = @BATCH_ROWCOUNT OUTPUT,
              @STATUS_CODE = @STATUS_CODE OUTPUT,
              @STATUS_DESC = @STATUS_DESC OUTPUT

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

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