USP_SIMPLEDATALIST_GLDEPARTMENT

                create procedure dbo.USP_SIMPLEDATALIST_GLDEPARTMENT
                as
                set nocount on;

                select 
                    ID as VALUE,
                    NAME as LABEL
                from
                    dbo.GLDEPARTMENT
                where
                    NAME <> ''
                order by
                    NAME;