USP_DATALIST_MEMBERSHIP_MEMBER_WITHALIASANDNICKNAME

Lists name information of members belonging to a membership.

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_MEMBERSHIP_MEMBER_WITHALIASANDNICKNAME(
                    @MEMBERSHIPID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        [MEMBERID],
                        [CONSTITUENTID],
                        [ISPRIMARY],
                        [ISDROPPED],
                        [ISCAREGIVER],
                        [FIRSTNAME],
                        [KEYNAME],
                        [HASDUPLICATEACTIVEMEMBERSHIP]
                    from dbo.UFN_MEMBERSHIP_MEMBER_WITHALIASANDNICKNAME(@MEMBERSHIPID)