USP_DATALIST_INTERACTIONCATEGORY

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

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