UFN_NAMEFORMATPARAMETER_GETORGSALUTATIONS

Returns the organization salutation options for the given name format parameter.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@NAMEFORMATPARAMETERID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_NAMEFORMATPARAMETER_GETORGSALUTATIONS
            (
                @NAMEFORMATPARAMETERID uniqueidentifier
            )
            returns table
            as
                return(select
                    ID,
                    coalesce(NAMEFORMATTYPECODEID, cast(N'00000000-0000-0000-0000-000000000001' as uniqueidentifier)) NAMEFORMATTYPECODEID,
                    SALUTATIONFORMATISPRIMARY,
                    SEQUENCE
                from dbo.NAMEFORMATPARAMETERORGSALUTATION
                where NAMEFORMATPARAMETERID = @NAMEFORMATPARAMETERID)