UFN_MEMBERSHIPLEVELTERM_GETVALUE
This function will return the term given the membership level term ID
Return
| Return Type |
|---|
| nvarchar(10) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MEMBERSHIPLEVELTERM_GETVALUE
(
@ID uniqueidentifier
)
returns nvarchar(10)
as
begin
declare @TERM nvarchar(10);
declare @TERMLENGTH nvarchar(6);
declare @TERMTIMELENGTH nvarchar(3);
select @TERMTIMELENGTH = TERMTIMELENGTH,
@TERMLENGTH = case TERMTIMELENGTH
when 1 then
case TERMLENGTHCODE
when 0 then 'month'
when 1 then 'year'
end
else
case TERMLENGTHCODE
when 0 then 'months'
when 1 then 'years'
end
end
from dbo.MEMBERSHIPLEVELTERM
where ID = @ID;
set @TERM = @TERMTIMELENGTH + ' ' + @TERMLENGTH
return @TERM;
end