UFN_REVENUEBATCH_GETMEMBERSHIPMEMBERMEMBERSHIPCARDS

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUEBATCH_GETMEMBERSHIPMEMBERMEMBERSHIPCARDS
            (
                @BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERID uniqueidentifier
            )
            returns table
            as return
            (
                select
                    ID,
                    NAMEONCARD,
                    EXPIRATIONDATE
                from dbo.BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERMEMBERSHIPCARD
                where BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERID = @BATCHREVENUEAPPLICATIONMEMBERSHIPMEMBERID
            )