USP_SIMPLEDATALIST_SPONSORINGINSTITUTION

Returns a list of sponsoring institutions.

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_SPONSORINGINSTITUTION
                as
                set nocount on;

                select 
                    ID as VALUE,
                    DESCRIPTION as LABEL
                from
                    dbo.FINANCIALINSTITUTION
                where
                    ISSPONSORINGINSTITUTION = 1;