UFN_NOTIFICATION_MEMBERSHIPID_MAPFROM_MEMBERID

Maps a MEMBERID to a MEMBERSHIPID for notifications

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_NOTIFICATION_MEMBERSHIPID_MAPFROM_MEMBERID(@MEMBERID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin

                DECLARE @ID uniqueidentifier;

                select
                    @ID = MEMBERSHIPID
                from
                    dbo.MEMBER
                where
                    MEMBER.ID = @MEMBERID;

                RETURN @ID;
            end