UFN_REGISTRANT_GETHOSTNAME_LFM

Checks if the registrant is a guest of a registrant, returns host name in last, first order.

Return

Return Type
nvarchar(124)

Parameters

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

Definition

Copy



            CREATE function dbo.UFN_REGISTRANT_GETHOSTNAME_LFM
            (
                @REGISTRANTID uniqueidentifier,
                @GUESTOFREGISTRANTID uniqueidentifier = null
            )
            returns nvarchar(124) with execute as caller
            as
            begin
                declare @HOSTNAME nvarchar(124)
                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