spClone_TargetedContentPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneContentID	int	IN
@ClonedContentID	int	IN
@CurrentUsersID	int	IN
@ClonedName	nvarchar(100)	IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spClone_TargetedContentPart]
        (
        @PKID int output,
        @CloneContentID int,
        @ClonedContentID int,
        @CurrentUsersID int,
        @ClonedName nvarchar(100)
        )
        AS
        BEGIN
        DECLARE @NewGuid uniqueidentifier
        SET @NewGuid = NEWID()

        INSERT INTO dbo.TargetedContentPart
        (
        SiteContentID,
        [Name],
        --PrimaryContentID,
        --DefaultContentID,
        Guid
        )
        SELECT
        @CloneContentID,
        @ClonedName,
        --PrimaryContentID,
        --DefaultContentID,
        @NewGuid

        SELECT @PKID = @@IDENTITY

        insert into dbo.targetedcontentchecks
        (
        TargetedPartID,
        PartOrder,
        ContentID
        )
        select
        @PKID,
        PartOrder,
        ContentID
        from dbo.TargetedContentChecks
        where TargetedPartID =  (select distinct(id) from dbo.targetedcontentpart where sitecontentid = @ClonedContentID)

        EXEC spAuditThis @CurrentUsersID, 1, @NewGuid, 1
        END