USP_SITECONTENT_COPY

Parameters

Parameter	Parameter Type	Mode
@TARGETID	int	IN
@SOURCEID	int	IN
@NewUserID	int	IN

Definition

Copy



CREATE procedure dbo.USP_SITECONTENT_COPY
(
    @TARGETID      int,
    @SOURCEID     int,
    @NewUserID    int
)
as
begin

    Update SiteContent Set XmlData = (Select XmlData from SiteContent Where ID = @SOURCEID), 
                           CopySourceID = @SOURCEID,
                           ChangedByCMSUserID = @NewUserID,
                           UpdateDate = getdate()
    Where ID = @TARGETID


    Update SiteContentVersion Set XmlData = (Select XmlData from SiteContent Where ID = @SOURCEID),
          StatusUpdatedOn = getdate(),  StatusUpdatedBy = @NewUserID
        Where SiteContentID = @TARGETID



    return 0;
end