USP_SIMPLEDATALIST_INDIVIDUALDISPLAYNAMEFORMATS

This datalist returns all available individual name formats in the system with a defined Inline Table Value Function.

Definition



            create procedure dbo.USP_SIMPLEDATALIST_INDIVIDUALDISPLAYNAMEFORMATS
            as
                set nocount on;

                select
                    ID as VALUE,
                    case when len(NF.EXAMPLE) = 0 then
                        dbo.UFN_NAMEFORMATFUNCTION_BUILDPROTOTYPE(ID)
                    else
                        NF.EXAMPLE
                    end as LABEL
                from dbo.NAMEFORMATFUNCTION NF
                    inner join sys.objects SO on NF.FORMATSQLTABLEVALUEFUNCTION = SO.[NAME] and SO.[TYPE] = 'IF'
                order by
                    NF.SEQUENCE;