spClone_NavBarItem

Parameters

Parameter	Parameter Type	Mode
@PKCloneID	int	IN
@PKCloneFromID	int	IN
@CurrentUsersID	int	IN

Definition

Copy


                CREATE    PROCEDURE [dbo].[spClone_NavBarItem]
(
      @PKCloneID        int,
    @PKCloneFromID  int,
    @CurrentUsersID int
)

AS
    declare @newGuid uniqueidentifier
    SET @newGuid = NEWID()

INSERT INTO NavBarItems
(
    ContentID,
    Caption,
    URL,
    SitePageID,
    DefaultSiteImageID,
    ActiveSiteImageID,
    HoverSiteImageID,
    [Sequence],
    PageTabID,
    Target,
    AddQS,
    DocumentID
)
select
        @PKCloneID,
    Caption,
    URL,
    SitePageID,
    DefaultSiteImageID,
    ActiveSiteImageID,
    HoverSiteImageID,
    [Sequence],
    PageTabID,
    Target,
    AddQS,
    DocumentID
from NavbarItems where ContentID = @PKCloneFromID


exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1