UFN_REGISTRANT_GETBENEFITLIST_BYREGISTRANTID
Return the FAF event sponsor's list of benefit name.
Return
| Return Type |
|---|
| nvarchar(4000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_REGISTRANT_GETBENEFITLIST_BYREGISTRANTID(@ID uniqueidentifier)
returns nvarchar(4000)
with execute as caller
as begin
-- do work here and return a value
declare @BENEFITSTRING nvarchar(max) = '';
select @BENEFITSTRING = @BENEFITSTRING +
case when @BENEFITSTRING = '' then B.NAME else '; ' + B.NAME end
from dbo.REGISTRANTBENEFIT RB(nolock)
inner join dbo.BENEFIT B(nolock)
on B.ID = RB.BENEFITID
where RB.REGISTRANTID = @ID;
return @BENEFITSTRING;
end