spClone_EducationEdit

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneContentID	int	IN
@ClonedContentID	int	IN
@CurrentUsersID	int	IN
Definition

Copy


    CREATE  Procedure dbo.spClone_EducationEdit
        (
        @PKID int output,
        @CloneContentID int,
        @ClonedContentID int,
        @CurrentUsersID int
        )
        as

        DECLARE @NewGuid uniqueidentifier
        SET @NewGuid = NEWID()

        Insert into EducationEdit
        (SiteContentID,
            [AllowAdd], 
            [AllowDelete], 
            [AllowPrimaryEdit], 
            [AllowPrimaryDelete],
            [PostPageID], 
            [Guid], 
            [PersonalPageDataID],
            [PrimaryShow], 
            [NoRecordMsg] 
        )
        Select @CloneContentID,
             [AllowAdd],
             [AllowDelete],
             [AllowPrimaryEdit],
             [AllowPrimaryDelete],
             [PostPageID],
             @NewGuid,
             [PersonalPageDataID],
            [PrimaryShow], 
            [NoRecordMsg] 
        From EducationEdit
        Where SiteContentiD = @ClonedContentID

        SELECT @PKID = @@Identity

        exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1

        exec spClone_ProfileEditorFields @CloneContentID,@ClonedContentID,@CurrentUsersID