UFN_MEMBERSHIPPROGRAM_GETENDDATE
Returns a collection of expiration dates for a membership program.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPPROGRAMID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_MEMBERSHIPPROGRAM_GETENDDATE
(
@MEMBERSHIPPROGRAMID uniqueidentifier
)
returns table
as
return
(
select
[ID],
[EXPIRATIONDATE],
[PUSHNEXTDATE],
[SEQUENCE]
from
dbo.MEMBERSHIPPROGRAMENDDATE
where
[MEMBERSHIPPROGRAMID] = @MEMBERSHIPPROGRAMID
)