UFN_CONSTITUENT_MAPFROM_SPONSORSHIP
Maps a sponsorship to the constituent who owns it.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CONSTITUENT_MAPFROM_SPONSORSHIP(
@SPONSORSHIPID uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as begin
declare @CONSTITUENTID uniqueidentifier;
select top 1
@CONSTITUENTID = CONSTITUENTID
from dbo.SPONSORSHIP
where ID = @SPONSORSHIPID;
return @CONSTITUENTID;
end