UFN_REGISTRANT_GETHOSTNAME

Checks if the registrant is a guest of a registrant.

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
            (
                @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 = NF.NAME
                    from 
                        dbo.REGISTRANT
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REGISTRANT.CONSTITUENTID) NF
                    where
                        REGISTRANT.ID = @GUESTOFREGISTRANTID;
                else
                    if exists(select ID from dbo.REGISTRANT where REGISTRANT.GUESTOFREGISTRANTID = @REGISTRANTID)
                        select 
                            @HOSTNAME = NF.NAME
                        from 
                            dbo.REGISTRANT
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REGISTRANT.CONSTITUENTID) NF
                        where
                            REGISTRANT.ID = @REGISTRANTID;

                return @HOSTNAME
            end