UFN_CONSITTID_MAPFROM_MAILPREFERENCEID

Maps a mail preference ID to a constituent ID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MAILPREFERENCEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CONSITTID_MAPFROM_MAILPREFERENCEID(@MAILPREFERENCEID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin

                DECLARE @ID uniqueidentifier;

                SELECT @ID=CONSTITUENTID from dbo.MAILPREFERENCE where ID=@MAILPREFERENCEID;

                RETURN @ID;

            end