USP_DATALIST_RESPONSECATEGORY

                    CREATE procedure dbo.USP_DATALIST_RESPONSECATEGORY @INCLUDEINACTIVE bit = 1
                    as
                        set nocount on;

                        select    
                            RC.ID,
                            RC.NAME,
                            RC.SORTMETHOD,
                            1-RC.ISINACTIVE
                        from 
                            dbo.RESPONSECATEGORY RC
                        where (@INCLUDEINACTIVE = 1 or RC.ISINACTIVE = 0)
                        order by
                            RC.NAME;