USP_FAFEVENTSOCIALNETWORK_COPY

create procedure dbo.USP_FAFEVENTSOCIALNETWORK_COPY
(
   @SOURCEID uniqueidentifier,
   @TARGETEVENTID uniqueidentifier,
   @CHANGEAGENTID uniqueidentifier = null
)
as
begin
     if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

     begin try
         if @SOURCEID is not null and @TARGETEVENTID is not null
             insert into FAFEVENTSOCIALNETWORKPROPERTY(
                     EventID,
                     TRANSACTIONTYPECODE,
                     PUBLISHCALLTEXT,
                     PUBLISHMESSAGETEXT,
                     MISSIONCALLTEXT,
                     MISSIONTEXT,
                     PUBLISHLOGO,
                     ISEMPTY,
                     ADDEDBYID,
                     CHANGEDBYID,
                     DATEADDED,
                     DATECHANGED)
             select @TARGETEVENTID,
                     TRANSACTIONTYPECODE,
                     PUBLISHCALLTEXT,
                     PUBLISHMESSAGETEXT,
                     MISSIONCALLTEXT,
                     MISSIONTEXT,
                     PUBLISHLOGO,
                     ISEMPTY,
                     @CHANGEAGENTID,
                     @CHANGEAGENTID,
                     GETDATE(),
                     GETDATE()
            from FAFEVENTSOCIALNETWORKPROPERTY
            where EVENTID = @SOURCEID 
        end try
    begin catch
      exec dbo.USP_RAISE_ERROR;
      return 1;
    end catch

    return 0;
end