UFN_BBNC_GETCONSTITUENTNAME_WITHSUFFIX

Return

Return Type
nvarchar(154)

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@MAPID	int	IN

Definition

Copy



create function dbo.UFN_BBNC_GETCONSTITUENTNAME_WITHSUFFIX(@CONSTITUENTID uniqueidentifier, @MAPID int) 
            returns nvarchar(154)
            as begin
                if @CONSTITUENTID is null and coalesce(@MAPID,0) > 0
                    select 
                        @CONSTITUENTID = ID 
                    from
                        dbo.CONSTITUENT
                    where
                        CONSTITUENT.SEQUENCEID = @MAPID;

            declare @CONSTITUENTNAME as nvarchar(100)

                set @CONSTITUENTNAME =    (select coalesce((select 
                                                CONCAT(NAME, SUFFIXCODE.DESCRIPTION) 
                                            from dbo.CONSTITUENT left join SUFFIXCODE 
                                                on CONSTITUENT.SUFFIXCODEID = SUFFIXCODE.ID
                                            where CONSTITUENT.ID= @CONSTITUENTID),''));

                return @CONSTITUENTNAME
            end