USP_DATALIST_PREVIOUSEVENTREGISTRANT
To see if a user was registered with the previous event.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | ConstituentID |
| @EVENTID | uniqueidentifier | IN | EventID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_PREVIOUSEVENTREGISTRANT(
@CONSTITUENTID uniqueidentifier,
@EVENTID uniqueidentifier
)with execute as caller
as
set nocount on;
DECLARE @PRIORYEAREVENTID uniqueidentifier
SELECT @PRIORYEAREVENTID = PRIORYEAREVENTID
FROM dbo.EVENTEXTENSION WITH (NOLOCK) WHERE EVENTID = @EVENTID
select
R.ID
from dbo.CONSTITUENT C
INNER JOIN REGISTRANT R
ON C.ID = R.CONSTITUENTID
WHERE C.ID = @CONSTITUENTID AND R.EVENTID = @PRIORYEAREVENTID