USP_DATALIST_SOCIALNETWORKMESSAGE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @TRANSACTIONTYPECODE | tinyint | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SOCIALNETWORKMESSAGE(
@EVENTID uniqueidentifier,
@TRANSACTIONTYPECODE tinyint = null
)
as
set nocount on;
select
FSNP.PUBLISHCALLTEXT, FSNP.PUBLISHMESSAGETEXT, FSNP.MISSIONCALLTEXT, FSNP.MISSIONTEXT, FSNP.PUBLISHLOGO, FSNP.ISEMPTY, EE.ISNEWSOCIALNETWORK
from FAFEVENTSOCIALNETWORKPROPERTY FSNP inner join EVENTEXTENSION EE
on FSNP.EVENTID = EE.EVENTID
where FSNP.EventID= @EVENTID and FSNP.TRANSACTIONTYPECODE= @TRANSACTIONTYPECODE