UFN_CONSTITID_MAPFROM_ALIASID

Maps a AliasID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@ALIASID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITID_MAPFROM_ALIASID(@ALIASID uniqueidentifier)
            returns uniqueidentifier
            as begin
                declare @ID uniqueidentifier;

                select
                    @ID = [CONSTITUENTID]
                from
                    dbo.[ALIAS]
                where
                    [ID] = @ALIASID;

                return @ID;
            end