spClone_SearchPart

Parameters

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

Definition

Copy


CREATE  Procedure [dbo].[spClone_SearchPart]
(
@PKID int output,
@CloneContentID int,
@ClonedContentID int,
@CurrentUsersID int
)
as

DECLARE @NewGuid uniqueidentifier
SET @NewGuid = NEWID()

    Insert into SearchPart
        (SiteContentID,
         [Name],
         [Description],
         SearchCaption,
         SiteSearchType,
         Guid
        )
     Select @CloneContentID, 
        [Name],
        [Description],
        SearchCaption,
        SiteSearchType,
        @NewGuid
     From SearchPart
     Where SiteContentiD = @ClonedContentID

SELECT @PKID = @@Identity

exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1

declare @CHANGEAGENTID uniqueidentifier
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

insert into dbo.SEARCHPART_CLIENTSITES ([SEARCHPARTID],[CLIENTSITESID],[ADDEDBYID],[CHANGEDBYID],[DATEADDED],[DATECHANGED])
select @PKID, SPCS.CLIENTSITESID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
from dbo.SEARCHPART_CLIENTSITES SPCS
inner join dbo.SearchPart SP on SP.ID = SPCS.[SEARCHPARTID]
where SP.SiteContentID = @ClonedContentID