UFN_MKTRECORDSOURCE_ISDONORRECORDSOURCE

Returns whether or not a record source is the donor record source.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTRECORDSOURCE_ISDONORRECORDSOURCE]
(
    @RECORDSOURCEID uniqueidentifier
)
returns bit
as

begin
    declare @ISDONORRECORDSOURCE bit;

    set @ISDONORRECORDSOURCE = 0;

  if exists (select top 1 1
               from dbo.[QUERYVIEWCATALOG]
               where [ID] = @RECORDSOURCEID
               and ([QUERYVIEWCATALOG].[QUERYVIEWSPEC].value('declare namespace bbafx="bb_appfx_queryview";
                                                             declare namespace c="bb_appfx_commontypes";
                                                             (bbafx:QueryViewSpec/c:MetaTags/@MarketingConstituentRecordSource)[1]','char(1)') = '1'))
    set @ISDONORRECORDSOURCE = 1;

    return @ISDONORRECORDSOURCE;
end