USP_SIMPLEDATALIST_EDUCATIONALINSTITUTIONQUERY

Returns a list of educational institutions for query.

Definition

Copy 


                CREATE procedure dbo.USP_SIMPLEDATALIST_EDUCATIONALINSTITUTIONQUERY
                as
                    set nocount on;

                select 
                    ID as VALUE,
                    NAME as LABEL
                from
                    dbo.EDUCATIONALINSTITUTION
                order by ISAFFILIATED desc, NAME;