UFN_CONSTITUENT_MAPFROM_NAMEFORMAT

Maps a name format to the constituent who owns it.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_MAPFROM_NAMEFORMAT
            (
                @NAMEFORMATID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;

                select top 1 
                    @CONSTITUENTID = CONSTITUENTID
                from dbo.NAMEFORMAT
                where ID = @NAMEFORMATID;

                return @CONSTITUENTID;
            end