USP_SIMPLEDATALIST_EDUCATIONALINVOLVEMENTNAME

                CREATE procedure dbo.USP_SIMPLEDATALIST_EDUCATIONALINVOLVEMENTNAME
                    (
                        @EDUCATIONALINVOLVEMENTTYPECODEID uniqueidentifier = null,
                        @INCLUDEALL bit = 0
                    )
                as
                    set nocount on;

                    select distinct
                        ID as VALUE,
                        NAME as LABEL
                    from EDUCATIONALINVOLVEMENTNAME
                    where
                        @INCLUDEALL = 1 or
                        (
                            INACTIVE = 0 and
                            @EDUCATIONALINVOLVEMENTTYPECODEID = EDUCATIONALINVOLVEMENTTYPECODEID
                        )
                    order by NAME