UFN_BBNC_MAPPINGRULENEEDSPAGEID

Returns 1 if a NETCOMMUNITYMAPPINGRULE entry needs one or more page IDs to be complete.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@NETCOMMUNITYMAPPINGRULEID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_BBNC_MAPPINGRULENEEDSPAGEID
            (
                @NETCOMMUNITYMAPPINGRULEID uniqueidentifier
            )
            returns bit
            as
            begin
                if (select MAPPINGTYPECODE from dbo.NETCOMMUNITYMAPPINGRULE where ID = @NETCOMMUNITYMAPPINGRULEID) = 2 
                    return 1;

                return 0;
            end