USP_DATALIST_MEMBERSHIP_CALCULATEEXPIRATIONDATEBYLEVEL
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPLEVELID | uniqueidentifier | IN | |
| @TERMID | uniqueidentifier | IN | |
| @STARTDATE | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_MEMBERSHIP_CALCULATEEXPIRATIONDATEBYLEVEL(@MEMBERSHIPLEVELID uniqueidentifier, @TERMID uniqueidentifier, @STARTDATE datetime)
as
set nocount on;
select dbo.UFN_MEMBERSHIP_CALCULATEEXPIRATIONDATEBYLEVEL(@MEMBERSHIPLEVELID, @TERMID, @STARTDATE) as EXPIRATIONDATE