USP_SIMPLELIST_PACKAGE

CREATE procedure dbo.USP_SIMPLELIST_PACKAGE
as
begin
    set nocount on;

    select
        MKTPACKAGE.ID [VALUE],
        MKTPACKAGE.NAME [LABEL]
    from
        dbo.MKTPACKAGE
    where 
        ISSYSTEM = 0
    order by
        NAME;

end