USP_BATCHTEMPLATE_GETDUPLICATECHECKTHRESHOLDS

Parameters

Parameter	Parameter Type	Mode
@BATCHTEMPLATEID	uniqueidentifier	IN
@DEFAULTCHECKFORDUPLICATES	bit	INOUT
@OVERALLMATCHTHRESHOLD	int	INOUT
@AUTOMATCHTHRESHOLD	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_BATCHTEMPLATE_GETDUPLICATECHECKTHRESHOLDS
(
    @BATCHTEMPLATEID uniqueidentifier,
    @DEFAULTCHECKFORDUPLICATES bit output,
    @OVERALLMATCHTHRESHOLD int output,
    @AUTOMATCHTHRESHOLD int output
)
as
begin

    select
        @DEFAULTCHECKFORDUPLICATES = DEFAULTCHECKFORDUPLICATES,
        @OVERALLMATCHTHRESHOLD = OVERALLMATCHTHRESHOLD,
        @AUTOMATCHTHRESHOLD = AUTOMATCHTHRESHOLD
    from 
        dbo.BATCHTEMPLATE
    where 
        ID = @BATCHTEMPLATEID

end