UFN_NAMEFORMAT_GETFORMATTEDNAME

Return

Return Type
nvarchar(700)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_NAMEFORMAT_GETFORMATTEDNAME(@ID UNIQUEIDENTIFIER) 
            returns nvarchar(700) with execute as caller
                as
                begin
                    declare @NAME nvarchar(700), @NAMEFORMATFUNCTIONID uniqueidentifier, @CONSTITUENTID uniqueidentifier;

                    select
                        @NAME = CUSTOMNAME,
                        @NAMEFORMATFUNCTIONID = NAMEFORMATFUNCTIONID,
                        @CONSTITUENTID = CONSTITUENTID
                    from
                        dbo.NAMEFORMAT where NAMEFORMAT.ID = @ID;

                    if @NAMEFORMATFUNCTIONID is not null
                        set @NAME = dbo.UFN_NAMEFORMAT_FROMID(@NAMEFORMATFUNCTIONID, @CONSTITUENTID)

                    return @NAME;
                END