USP_FAFEventInfo_DATALIST
FAFEventInfo.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | EVENTID |
Definition
Copy
CREATE procedure dbo.USP_FAFEventInfo_DATALIST
@EVENTID uniqueidentifier = null
as
set nocount on;
select m.EMAILADDRESS, m.EMAILADDRESSTYPECODEID, dbo.UFN_EMAILADDRESSTYPECODE_GETDESCRIPTION(m.EMAILADDRESSTYPECODEID) as TYPE,
c.ID as ContactID, c.NAME as ContactName, e.NAME from event e (nolock)
left outer join CONSTITUENT c (nolock) on (e.EVENTLOCATIONCONTACTID = c.ID)
left outer join EMAILADDRESS m (nolock) on (m.CONSTITUENTID = c.ID)
where e.ID= @EVENTID