USP_SIMPLEDATALIST_EDUCATIONALINSTITUTION_NONAFFILIATED

REturns all the educational institutions in the system that are not affiliated.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_EDUCATIONALINSTITUTION_NONAFFILIATED as
                    select 
                        ID as VALUE, 
                        NAME as LABEL
                    from dbo.EDUCATIONALINSTITUTION
                    where ISAFFILIATED = 0
                    order by NAME