USP_DATALIST_NAMEFORMATFUNCTION

CREATE procedure dbo.USP_DATALIST_NAMEFORMATFUNCTION
as
    set nocount on;

    select NAMEFORMATFUNCTION.ID, 
        case when len(NAMEFORMATFUNCTION.EXAMPLE) = 0 then
            dbo.[UFN_NAMEFORMATFUNCTION_BUILDPROTOTYPE](NAMEFORMATFUNCTION.ID)
        else
            NAMEFORMATFUNCTION.EXAMPLE
        end as EXAMPLE,
        case when HOUSEHOLDINFO.ID is null then 0 else 1 end HOUSEHOLDNAMEFORMAT,
        case when NAMEFORMATFUNCTION_USERDEFINED.ID is null then 0 else 1 end USERDEFINED,
        ISJOINTFUNCTION
    from NAMEFORMATFUNCTION
    left outer join dbo.NAMEFORMATFUNCTION_USERDEFINED
        on NAMEFORMATFUNCTION.ID = NAMEFORMATFUNCTION_USERDEFINED.ID
    left outer join dbo.HOUSEHOLDINFO
        on NAMEFORMATFUNCTION.ID = HOUSEHOLDINFO.NAMEFORMATFUNCTIONID
    order by SEQUENCE