USP_SIMPLEDATALIST_PDACCOUNTCODEMAPFACILITY

CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPFACILITY as
    select
        VALUE,
        LABEL
    from (
        select
            '99999999-9999-9999-9999-999999999999' as VALUE,
            'All locations' as LABEL,
            0 as SEQUENCE

        union all

        select
            ID as VALUE, 
            NAME as LABEL,
            1 as SEQUENCE
        from
            dbo.EVENTLOCATION
    ) as FACILITIES
    order by
        SEQUENCE, LABEL;