USP_FAFSOCIALNETWORKMESSAGE_LOAD

create procedure dbo.USP_FAFSOCIALNETWORKMESSAGE_LOAD
(
  @EventID uniqueidentifier,
  @TransactionTypeCode tinyint
)
as
  set nocount on;

  select
    PUBLISHCALLTEXT, PUBLISHMESSAGETEXT, MISSIONCALLTEXT, MISSIONTEXT, PUBLISHLOGO, ISEMPTY
  from FAFEVENTSOCIALNETWORKPROPERTY (nolock)
  where EventID= @EventID and TRANSACTIONTYPECODE= @TransactionTypeCode