UFN_CONSTITID_MAPFROM_RELATIONSHIPMANAGERID

Maps a RelationshipManagerID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@RELATIONSHIPMANAGERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITID_MAPFROM_RELATIONSHIPMANAGERID(@RELATIONSHIPMANAGERID uniqueidentifier)
            returns uniqueidentifier
            as begin
                declare @ID uniqueidentifier;

                select
                    @ID = [CONSTITUENTID]
                from
                    dbo.[RELATIONSHIPMANAGER]
                where
                    [ID] = @RELATIONSHIPMANAGERID;

                return @ID;
            end