USP_SEARCHLIST_TASKWIZARD

create procedure dbo.USP_SEARCHLIST_TASKWIZARD
(
    @MAXROWS smallint = 500,
    @NAME nvarchar(100) = null
)
as
    set nocount on;

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

    select top(@MAXROWS)
        T.ID,
        T.NAME,
        T.DESCRIPTION
    from 
        dbo.TASKWIZARDCATALOG as T
    where (@NAME is null) or (T.NAME like @NAME)
    order by T.NAME asc