USP_SIMPLEDATALIST_SOLICITOR_FULL

CREATE procedure dbo.USP_SIMPLEDATALIST_SOLICITOR_FULL as
select distinct
    c.[NAME] as VALUE, 
    c.[NAME] as LABEL
from dbo.REVENUESOLICITOR S
inner join dbo.CONSTITUENT C on S.CONSTITUENTID = C.ID
order by c.[NAME]