USP_DATALIST_NAMEFORMATFIELD

CREATE procedure dbo.USP_DATALIST_NAMEFORMATFIELD
as
    set nocount on;

    select 
        NAMEFORMATFIELD.[ID],
        NAMEFORMATFIELD.[DISPLAY]
    from 
        dbo.NAMEFORMATFIELD
    where NAMEFORMATFIELD.[FIELDCODE] = 0 -- user defined

    order by
        NAMEFORMATFIELD.[SEQUENCE]