UFN_MKTRECORDSOURCE_GETFIRSTBBECRECORDSOURCEID

Returns the first record source ID for a valid BBEC recordsource.

Return

Return Type
uniqueidentifier

Definition

Copy



create function dbo.[UFN_MKTRECORDSOURCE_GETFIRSTBBECRECORDSOURCEID]()
returns uniqueidentifier
as

begin
    declare @RECORDSOURCEID uniqueidentifier;

    select top 1
    @RECORDSOURCEID = [ID]
    from
    dbo.[MKTRECORDSOURCE]
    where dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]([ID]) = 1;

    return @RECORDSOURCEID;
end