USP_SIMPLEDATALIST_EDUCATIONALINSTITUTION

                CREATE procedure dbo.USP_SIMPLEDATALIST_EDUCATIONALINSTITUTION
                (
                    @INCLUDEAFFILIATED bit = 1,
                    @INCLUDEUNAFFILIATED bit = 1
                )
                as
                set nocount on;

                select 
                    ID as VALUE,
                    case when ISAFFILIATED = 1 then NAME + ' *' else NAME end as LABEL
                    --NAME as LABEL

                from
                    dbo.EDUCATIONALINSTITUTION
                where (@INCLUDEAFFILIATED = 1 OR ISAFFILIATED = 0)
                      and
                      (@INCLUDEUNAFFILIATED = 1 OR ISAFFILIATED = 1)
                order by ISAFFILIATED desc, NAME;