UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPCARDS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHMEMBERSHIPDUESID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPCARDS
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return (
    select
        ID,
        CONSTITUENTID,
        NAMEONCARD,
        EXPIRATIONDATE
    from dbo.BATCHMEMBERSHIPDUESMEMBERSHIPCARD
    where BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
)