UFN_BBNC_GETREGISTRANTIDFROMCONSTITMAPID
Returns the registrant ID for the specified event ID and constituent integer mapping ID for Blackbaud Internet Solutions.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITID | int | IN | |
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_BBNC_GETREGISTRANTIDFROMCONSTITMAPID
(
@CONSTITID int,
@EVENTID uniqueidentifier
)
returns uniqueidentifier
as begin
return (
select top 1
[REGISTRANT].[ID]
from
dbo.CONSTITUENT
inner join dbo.REGISTRANT on [CONSTITUENT].[ID] = [REGISTRANT].[CONSTITUENTID]
where
[CONSTITUENT].[SEQUENCEID] = @CONSTITID
and [REGISTRANT].[EVENTID] = @EVENTID
)
end