USP_DATALIST_MERCHANDISE_VENDOR

            CREATE procedure dbo.USP_DATALIST_MERCHANDISE_VENDOR
            as
                set nocount on;

                select C.ID,
                       C.NAME,
                       dbo.UDA_BUILDLIST(P.NAME) MERCHANDISEITEMS
                from dbo.CONSTITUENT C
                inner join dbo.VENDOR V on V.ID = C.ID
                left outer join dbo.PRODUCTVENDOR PV on PV.VENDORID = V.ID
                left outer join dbo.MERCHANDISEPRODUCT MP on PV.PRODUCTID = MP.ID
                left outer join dbo.PRODUCT P on P.ID = MP.ID
                group by C.ID,C.NAME
                order by C.NAME