USP_SEARCH_BATCHTEMPLATE

Search for batch templates.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(60)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.USP_SEARCH_BATCHTEMPLATE
(
    @NAME nvarchar(60) = null,
    @DESCRIPTION nvarchar(1000) = null,
    @MAXROWS smallint = 500
)
as
    set nocount on;

    set @NAME = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@NAME, 0, null);
    set @DESCRIPTION = dbo.UFN_SEARCHCRITERIA_GETLIKEPARAMETERVALUE(@DESCRIPTION, 0, null);

    select top(@MAXROWS) 
        ID, 
        NAME, 
        DESCRIPTION 
    from dbo.BATCHTEMPLATE
    where ((@NAME is null) or (NAME like @NAME)) and 
          ((@DESCRIPTION is null) or (DESCRIPTION like @DESCRIPTION))