UFN_EVENTGROUPMEMBER_VALIDREGISTRANT
Validates that the registrant is a registrant for the proper event.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTGROUPID | uniqueidentifier | IN | |
| @REGISTRANTID | uniqueidentifier | IN |
Definition
Copy
create function UFN_EVENTGROUPMEMBER_VALIDREGISTRANT
(
@EVENTGROUPID uniqueidentifier,
@REGISTRANTID uniqueidentifier
)
returns bit
with execute as caller
as
begin
if not exists(
select
REGISTRANT.ID
from
dbo.EVENTGROUPMEMBER
inner join dbo.REGISTRANT ON REGISTRANT.ID = EVENTGROUPMEMBER.REGISTRANTID
inner join dbo.EVENTGROUP on EVENTGROUP.ID = EVENTGROUPMEMBER.EVENTGROUPID
where
REGISTRANT.ID = @REGISTRANTID and
EVENTGROUP.ID = @EVENTGROUPID and
REGISTRANT.EVENTID = EVENTGROUP.EVENTID)
return 0
return 1
end