UFN_REGISTRANT_GETHOSTNAME_LASTNAMESORT

Return

Return Type
nvarchar(700)

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTID	uniqueidentifier	IN
@GUESTOFREGISTRANTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_REGISTRANT_GETHOSTNAME_LASTNAMESORT
(
    @REGISTRANTID uniqueidentifier,
    @GUESTOFREGISTRANTID uniqueidentifier = null
)
            returns nvarchar(700) with execute as caller
            as
            begin
                declare @HOSTNAME nvarchar(700)
                set @HOSTNAME = '';

                if @GUESTOFREGISTRANTID is not null
                    select 
                        @HOSTNAME = dbo.UFN_CONSTITUENT_SORTNAME(REGISTRANT.CONSTITUENTID)
                    from 
                        dbo.REGISTRANT
                    where
                        REGISTRANT.ID = @GUESTOFREGISTRANTID;
                else
                    if exists(select ID from dbo.REGISTRANT where REGISTRANT.GUESTOFREGISTRANTID = @REGISTRANTID)
                        select 
                            @HOSTNAME = dbo.UFN_CONSTITUENT_SORTNAME(REGISTRANT.CONSTITUENTID)
                        from 
                            dbo.REGISTRANT
                        where
                            REGISTRANT.ID = @REGISTRANTID;

                return @HOSTNAME
            end