UFN_BATCHMEMBERSHIP_GETMEMBERS

Returns all members for a given batch membership record

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHMEMBERSHIPID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_BATCHMEMBERSHIP_GETMEMBERS
        (
            @BATCHMEMBERSHIPID uniqueidentifier
        ) 
        returns table
        as return
        (
            select
                [BATCHMEMBERSHIPMEMBER].[ID],
                [BATCHMEMBERSHIPMEMBER].[CONSTITUENTID],
                [BATCHMEMBERSHIPMEMBER].[ISPRIMARY]
            from
                dbo.[BATCHMEMBERSHIPMEMBER]
            where
                [BATCHMEMBERSHIPMEMBER].[BATCHMEMBERSHIPID] = @BATCHMEMBERSHIPID
        );