UFN_MKTSOURCEANALYSISRULE_GETRECORDSOURCEINFO

Retrieves the display name and record type of a specific record source.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSOURCEANALYSISRULE_GETRECORDSOURCEINFO]
(
  @RECORDSOURCEID uniqueidentifier
)
returns table
as
  return (select
            [QUERYVIEWCATALOG].[DISPLAYNAME] as [NAME],
            [RECORDTYPE].[NAME] as [RECORDTYPE],
            [QUERYVIEWCATALOG].[OBJECTNAME] as [QUERYVIEWNAME],
            [QUERYVIEWCATALOG].[PRIMARYKEYFIELD]
          from dbo.[QUERYVIEWCATALOG]
            inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [QUERYVIEWCATALOG].[RECORDTYPEID]
            left join dbo.[MKTRECORDSOURCE] on [MKTRECORDSOURCE].[ID] = [QUERYVIEWCATALOG].[ID]
          where [MKTRECORDSOURCE].[ID] = @RECORDSOURCEID and dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1
         )