UFN_SITEID_MAPFROM_PLANNEDGIFTLETTERCODEID
Maps a planned gift letter to multiple sites.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTLETTERCODEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_SITEID_MAPFROM_PLANNEDGIFTLETTERCODEID]
(
@PLANNEDGIFTLETTERCODEID uniqueidentifier
)
returns table
as
return
select [PLANNEDGIFTLETTERCODESITE].[SITEID]
from dbo.[PLANNEDGIFTLETTERCODE]
left outer join dbo.[PLANNEDGIFTLETTERCODESITE] on [PLANNEDGIFTLETTERCODESITE].[PLANNEDGIFTLETTERCODEID] = [PLANNEDGIFTLETTERCODE].[ID]
where [PLANNEDGIFTLETTERCODE].[ID] = @PLANNEDGIFTLETTERCODEID;