USP_SIMPLEDATALIST_RESPONSECATEGORY

            CREATE procedure dbo.USP_SIMPLEDATALIST_RESPONSECATEGORY
            as
                set nocount on;

                select 
                    RC.ID as VALUE,
                    RC.NAME as LABEL
                from
                    dbo.RESPONSECATEGORY as RC
                where RC.ISINACTIVE = 0
                order by
                    RC.NAME;