USP_SIMPLEDATALIST_PATTERN

                CREATE procedure dbo.USP_SIMPLEDATALIST_PATTERN 
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                select 
                    ID as VALUE, 
                    NAME as LABEL
                from dbo.PATTERN
                where
                    (
                        (@INCLUDEINACTIVE = 1) 
                        or 
                        (ISACTIVE = 1)
                    )
                order by NAME