UFN_REGISTRANT_GETHOSTNAMEDIRECTORYSTYLE

Return

Return Type
nvarchar(700)

Parameters

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

Definition

Copy



create function dbo.UFN_REGISTRANT_GETHOSTNAMEDIRECTORYSTYLE
(
    @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_NAMEFORMAT_08(CONSTITUENT.ID, CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, null, null, null, null, null, null, null)
        from 
            dbo.REGISTRANT
            inner join dbo.CONSTITUENT on REGISTRANT.CONSTITUENTID = CONSTITUENT.ID
        where
            REGISTRANT.ID = @GUESTOFREGISTRANTID;
    else
        if exists(select ID from dbo.REGISTRANT where REGISTRANT.GUESTOFREGISTRANTID = @REGISTRANTID)
            select 
                @HOSTNAME = dbo.UFN_NAMEFORMAT_08(CONSTITUENT.ID, CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME, CONSTITUENT.MIDDLENAME, null, null, null, null, null, null, null)
            from 
                dbo.REGISTRANT
                inner join dbo.CONSTITUENT on REGISTRANT.CONSTITUENTID = CONSTITUENT.ID
            where
                REGISTRANT.ID = @REGISTRANTID;

    return @HOSTNAME;
end