UFN_PLANNEDGIFT_GETSITELIST
Returns a comma delimited list of sites associated with the given planned gift.
Return
| Return Type |
|---|
| nvarchar(1024) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PLANNEDGIFT_GETSITELIST
(
@PLANNEDGIFTID uniqueidentifier
)
returns nvarchar(1024)
as
begin
declare @SITES nvarchar(1024) =
(
select
dbo.UDA_BUILDLIST(SITE.NAME)
from
dbo.UFN_PLANNEDGIFT_GETSITES(@PLANNEDGIFTID) PLANNEDGIFTSITE
inner join
dbo.SITE
on
SITE.ID = PLANNEDGIFTSITE.SITEID
);
return @SITES;
end