UFN_MEMBERSHIPLEVEL_GETBENEFITS
Returns all benefits for a given membership level record.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPLEVELID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MEMBERSHIPLEVEL_GETBENEFITS(@MEMBERSHIPLEVELID uniqueidentifier)
returns table
as
return
(
select
[ID],
[BENEFITID],
[QUANTITY],
[UNITVALUE],
QUANTITY * UNITVALUE as [TOTALVALUE],
[DETAILS],
[SEQUENCE]
from dbo.MEMBERSHIPLEVELBENEFIT
where MEMBERSHIPLEVELID = @MEMBERSHIPLEVELID
)