USP_SEARCHLIST_RECOGNITIONPROGRAMS

CREATE procedure dbo.USP_SEARCHLIST_RECOGNITIONPROGRAMS
(
  @NAME nvarchar(100) = null,
  @SITEID uniqueidentifier = null,
  @INCLUDEINACTIVE bit = 0,
  @TYPECODE tinyint = null,
  @MAXROWS smallint = 500
)
as
  set @NAME = '%' + COALESCE(@NAME,'') + '%' ;

  select top(@MAXROWS)
    RECOGNITIONPROGRAM.ID,
    RECOGNITIONPROGRAM.NAME,
    RECOGNITIONPROGRAM.DESCRIPTION,
    RECOGNITIONPROGRAM.TYPE,
    SITE.NAME,
    RECOGNITIONPROGRAM.EXPIRESON,
    RECOGNITIONPROGRAM.ISACTIVE
  from dbo.RECOGNITIONPROGRAM
    left outer join dbo.SITE on RECOGNITIONPROGRAM.SITEID = SITE.ID
  where
    RECOGNITIONPROGRAM.NAME LIKE @NAME
    and (@SITEID is null or RECOGNITIONPROGRAM.SITEID = @SITEID)
    and (@INCLUDEINACTIVE = 1 or RECOGNITIONPROGRAM.ISACTIVE = 1)
    and (@TYPECODE is null or RECOGNITIONPROGRAM.TYPECODE = @TYPECODE)
  order by 
    RECOGNITIONPROGRAM.NAME asc;