USP_SIMPLEDATALIST_PRODUCTVENDOR

            CREATE procedure dbo.USP_SIMPLEDATALIST_PRODUCTVENDOR as
            select
                V.ID as VALUE, 
                C.NAME as LABEL
            from dbo.VENDOR V
            inner join dbo.CONSTITUENT C on C.ID = V.ID
            order by C.NAME