USP_SIMPLEDATALIST_MEMBERCONSTITUENTID

This simple datalist returns all members for a given membership using their constituent ID.

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPID	uniqueidentifier	IN	MEMBERSHIPID
@INCLUDEDROPPED	bit	IN	INCLUDEDROPPED

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERCONSTITUENTID
                (
                    @MEMBERSHIPID uniqueidentifier,
                    @INCLUDEDROPPED bit = 1
                )
                as
                    set nocount on;

                    select
                        M.CONSTITUENTID [VALUE],
                        NF.NAME LABEL
                    from
                        dbo.MEMBERSHIP MS
                        inner join dbo.MEMBER M on MS.ID = M.MEMBERSHIPID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(M.CONSTITUENTID) NF
                    where
                        (@INCLUDEDROPPED = 1 or M.ISDROPPED = 0) and
                        MS.ID = @MEMBERSHIPID
                    order by
                        LABEL