UFN_EVENT_CONSTITUENTISSPONSOR
Check if the current constituent is an event sponsor.
Return
| Return Type |
|---|
| tinyint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @CONSTITUENTID | uniqueidentifier | IN | |
| @ORGANIZATIONCONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_EVENT_CONSTITUENTISSPONSOR
(
@EVENTID uniqueidentifier,
@CONSTITUENTID uniqueidentifier,
@ORGANIZATIONCONSTITUENTID uniqueidentifier = null
)
returns tinyint
-- with execute as caller
as
begin
if exists(select ID from dbo.EVENTSPONSOR ES(nolock) where ES.CONSTITUENTID = @CONSTITUENTID and ES.EVENTID = @EVENTID)
begin
return 1;
end;
if @ORGANIZATIONCONSTITUENTID is not null
if exists(select ID from dbo.EVENTSPONSOR ES(nolock) where ES.ORGANIZATIONCONSTITUENTID = @ORGANIZATIONCONSTITUENTID and ES.EVENTID = @EVENTID)
begin
return 2;
end;
return 0;
end