USP_CLONESITE_MENU

CREATE procedure dbo.USP_CLONESITE_MENU
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
as


    INSERT INTO dbo.SiteMenu 
    SELECT
    SC.ID,
    SM.ActiveCSS,
    SM.Orientation,
    SM.MenuCSS,
    SM.HoverCSS,
    SM.DefaultCSS,
    SM.SubitemCSS,
    SM.SubmenuGlyphID,
    SM.ClickToOpen,
    SM.GlyphLocation,
    SM.MenuTechnology,
    SM.MSStyleStaticMenu,
    SM.MSStyleStaticItem,
    SM.MSStyleStaticHover,
    SM.MSStyleStaticSelected,
    SM.MSStyleDynamicMenu,
    SM.MSStyleDynamicItem,
    SM.MSStyleDynamicHover,
    SM.MSStyleDynamicSelected,
    SM.MSMenuOptions,
    SM.MenuContainerDivClass,
    SM.MenuActiveClass,
    SM.MenuClass,
    SM.MenuItemClass,
    SM.MenuHoverClass,
    SM.MenuSubItemClass                
    from dbo.SiteMenu SM
    inner join dbo.SiteContent SC on SC.CopySourceID = SM.ContentID
    where SC.CopyBatchGUID = @CopyBatchGUID

    INSERT INTO MenuItems
    (ContentID, ID, ParentID, Caption, Tooltip, SitePageID, PageTabID, URL, Target, RightImgPad, TreeIndex, LinkType, IsActive, PageTitle, CssClass)
    SELECT
        SiteContent.ID,
        MenuItems.ID,
        MenuItems.ParentID,
        MenuItems.Caption, 
        MenuItems.Tooltip, 
        ISNULL(sp.ID,MenuItems.SitePageID), 
        MenuItems.PageTabID, 
        MenuItems.URL, 
        MenuItems.Target, 
        MenuItems.RightImgPad, 
        MenuItems.TreeIndex, 
        MenuItems.LinkType,
        MenuItems.IsActive,
        MenuItems.PageTitle,
        MenuItems.CssClass
    FROM MenuItems
    INNER JOIN SiteContent ON SiteContent.CopySourceID = MenuItems.ContentID AND SiteContent.CopyBatchGuid = @CopyBatchGuid
    LEFT JOIN SitePages sp ON sp.CopySourceID = MenuItems.SitePageID AND sp.CopyBatchGUID = @CopyBatchGUID