UFN_MKTGIFTRECORDSOURCE_ISGIFTRECORDSOURCE

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

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN

Definition

Copy



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

begin
    declare @ISGIFTRECORDSOURCE bit;

    set @ISGIFTRECORDSOURCE = 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/@MarketingGiftRecordSource)[1]','char(1)') = '1'))
    set @ISGIFTRECORDSOURCE = 1;

    return @ISGIFTRECORDSOURCE;
end