USP_SIMPLEDATALIST_NAMEFORMATS

            CREATE procedure dbo.USP_SIMPLEDATALIST_NAMEFORMATS(@CONSTITUENTID uniqueidentifier = null)
            as
                set nocount on;

                select
                    ID as VALUE,
                    case
                        when (@CONSTITUENTID is null) then
                            case when len(NF.EXAMPLE) = 0 then
                                dbo.UFN_NAMEFORMATFUNCTION_BUILDPROTOTYPE(ID)
                            else
                                NF.EXAMPLE
                            end
                        else
                            dbo.UFN_NAMEFORMAT_FROMID(NF.ID,@CONSTITUENTID)
                    end as LABEL
                from
                    dbo.NAMEFORMATFUNCTION NF
                where 
                    /* if no constituent show all */
                    @CONSTITUENTID is null    
                    or 
                    /* if there is a constituent only show relevant */
                    dbo.UFN_NAMEFORMAT_FROMID(NF.ID,@CONSTITUENTID) <> ''
                order by
                    NF.SEQUENCE;