USP_SIMPLEDATALIST_SPONSORSHIPAFFILIATE

        create procedure dbo.USP_SIMPLEDATALIST_SPONSORSHIPAFFILIATE as
        select 
            SA.ID as VALUE, 
            NAME as LABEL
            from dbo.SPONSORSHIPAFFILIATEPROGRAM SA
            inner join dbo.CONSTITUENT CO on CO.ID = SA.AFFILIATEID
          order by NAME