USP_SIMPLEDATALIST_INTERACTIONCATEGORY

            create procedure dbo.USP_SIMPLEDATALIST_INTERACTIONCATEGORY(@INCLUDEINACTIVE bit = 0)
            as
                set nocount on;

                select 
                    IC.ID as VALUE,
                    IC.NAME as LABEL
                from
                    dbo.INTERACTIONCATEGORY as IC
                where (IC.ISINACTIVE = 0 or @INCLUDEINACTIVE=1)
                order by
                    IC.NAME;