USP_RECORDSOURCESEARCH

Search for record sources.

Parameters

Parameter	Parameter Type	Mode	Description
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.
@RECORDSOURCENAME	nvarchar(100)	IN	Record source name

Definition

Copy



CREATE procedure dbo.USP_RECORDSOURCESEARCH
(
  @MAXROWS smallint,
  @RECORDSOURCENAME nvarchar(100) = null
)
as
  set nocount on;

  select distinct
    [QUERYVIEWCATALOG].[ID], 
    [QUERYVIEWCATALOG].[DISPLAYNAME] as [NAME]
  from 
    dbo.[QUERYVIEWCATALOG]
  inner join 
    dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [QUERYVIEWCATALOG].[RECORDTYPEID]
  inner join 
    dbo.[MKTRECORDSOURCE] on [MKTRECORDSOURCE].[ID] = [QUERYVIEWCATALOG].[ID]
  where
    [QUERYVIEWCATALOG].[ROOTOBJECT] = 1
  and 
    [QUERYVIEWCATALOG].[DISPLAYNAME] like coalesce(@RECORDSOURCENAME, '') + '%'
  and
    dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([QUERYVIEWCATALOG].[ID]) = 1
  order by 
    [QUERYVIEWCATALOG].[DISPLAYNAME];

  return 0;