UFN_CONSTITID_FROM_MEMBERID

Maps a CONSTITID from MEMBERID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MEMBERID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CONSTITID_FROM_MEMBERID
            (
                @MEMBERID uniqueidentifier
            )
            returns uniqueidentifier
            as begin
                declare @ID uniqueidentifier;

                select
                    @ID = CONSTITUENTID
                from
                    dbo.MEMBER
                where
                    ID = @MEMBERID

                return @ID;
            end