UFN_MKTMEMBERSHIPRECORDSOURCE_ISMEMBERSHIPRECORDSOURCE
Returns whether or not a record source is the membership record source.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDSOURCEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTMEMBERSHIPRECORDSOURCE_ISMEMBERSHIPRECORDSOURCE]
(
@RECORDSOURCEID uniqueidentifier
)
returns bit
as
begin
declare @ISMEMBERSHIPRECORDSOURCE bit;
set @ISMEMBERSHIPRECORDSOURCE = 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/@MarketingMembershipRecordSource)[1]','char(1)') = '1'))
set @ISMEMBERSHIPRECORDSOURCE = 1;
return @ISMEMBERSHIPRECORDSOURCE;
end