UFN_MEMBERSHIPDUESBATCH_GETMEMBERSFORCONTEXTVIEW

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERSFORCONTEXTVIEW
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as return
    select
        C.NAME,
        C.LOOKUPID
    from dbo.BATCHMEMBERSHIPDUESMEMBER BMDM
        inner join dbo.CONSTITUENT C
            on BMDM.CONSTITUENTID = C.ID
    where
        BMDM.BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID