USP_SIMPLEDATALIST_MEMBER
This simple datalist returns all members for a given membership.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPID | uniqueidentifier | IN | MEMBERSHIPID |
| @INCLUDEDROPPED | bit | IN | INCLUDEDROPPED |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBER
(
@MEMBERSHIPID uniqueidentifier,
@INCLUDEDROPPED bit = 1
)
as
set nocount on;
select
M.ID [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
MS.ID = @MEMBERSHIPID
and (
@INCLUDEDROPPED = 1
or M.ISDROPPED = 0
)
order by
LABEL