USP_SIMPLEDATALIST_MEMBERSHIPLEVEL
This simple datalist returns all levels for a given membership program.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPPROGRAMID | uniqueidentifier | IN | MEMBERSHIPPROGRAMID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPLEVEL
(
@MEMBERSHIPPROGRAMID uniqueidentifier
)
as
set nocount on;
select
ID as VALUE,
NAME as LABEL
from
dbo.MEMBERSHIPLEVEL
where
MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID
and ISACTIVE = 1
order by SEQUENCE asc;