USP_DATALIST_NAMEFORMATDEFAULT

            CREATE procedure dbo.USP_DATALIST_NAMEFORMATDEFAULT
            as
                set nocount on;

                select NFD.ID,
                       NFD.APPLYTO,
                       NFTC.DESCRIPTION as NAMEFORMATTYPE,
                       dbo.UFN_NAMEFORMATFUNCTION_BUILDPROTOTYPE(NFD.NAMEFORMATFUNCTIONID) as NAMEFORMATFUNCTION 
                from dbo.NAMEFORMATDEFAULT as NFD
                left join
                    dbo.NAMEFORMATTYPECODE NFTC
                    on NFTC.ID = NFD.NAMEFORMATTYPECODEID