USP_EVENTCAMPAIGN_COPY

Copies campaigns from one event to another event.
Parameters

Parameter	Parameter Type	Mode
@SOURCEEVENTID	uniqueidentifier	IN
@DESTINATIONEVENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


create procedure dbo.USP_EVENTCAMPAIGN_COPY
            (
                @SOURCEEVENTID uniqueidentifier,
                @DESTINATIONEVENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null
            )
            with execute as caller
            as
                set nocount on;

                -- Cannot copy if the source event does not exist

                if not exists (select ID from dbo.EVENT where ID = @SOURCEEVENTID)
                    raiserror('The source event specified does not exist.',13,1);

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                insert into dbo.EVENTCAMPAIGN
                (
                    EVENTID,
                    CAMPAIGNID,
                    CAMPAIGNSUBPRIORITYID,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )
                select
                    @DESTINATIONEVENTID,
                    CAMPAIGNID,
                    CAMPAIGNSUBPRIORITYID,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                from
                    dbo.EVENTCAMPAIGN
                where
                    EVENTID = @SOURCEEVENTID;

                return 0;