UFN_STEWARDSHIPPLANSTEP_ASSOCIATEDPLANS_TOCOMMASEPARATEDLIST
Returns a comma separated list of the major giving plans to which this step has been associated.
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STEPID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_STEWARDSHIPPLANSTEP_ASSOCIATEDPLANS_TOCOMMASEPARATEDLIST
(
@STEPID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier
)
returns nvarchar(max)
as begin
declare @PLANS nvarchar(max);
set @PLANS = '';
select
@PLANS += PLANNAME + ', '
from dbo.UFN_STEWARDSHIPPLANSTEP_ASSOCIATEDPLANS(@STEPID, @CURRENTAPPUSERID)
order by PLANNAME;
if len(@PLANS) > 2
set @PLANS = left(rtrim(@PLANS), len(@PLANS) - 1);
return @PLANS;
end