spBulkUpdate_NavBarItems

                CREATE     PROCEDURE [dbo].[spBulkUpdate_NavBarItems]
(
@ContentId int,
@XML ntext
)

AS

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

DELETE 
FROM NavBarItems
WHERE ContentID=@ContentID 

INSERT INTO NavBarItems(
    ContentID,
    [Sequence],
    Caption,
    URL,
    SitePageID,
    DefaultSiteImageID,
    HoverSiteImageID,
    ActiveSiteImageID,
    PageTabID,
    Target,
    AddQS,
    DocumentID

) SELECT
@ContentID, [Sequence], Caption, URL, SitePageID, DefaultSiteImageID, HoverSiteImageID, ActiveSiteImageId, PageTabID, Target, AddQS, DocumentID
FROM OPENXML (@idoc, '/NavBarItems/Items/Item',1) 
    WITH(
        ID int,
        [Sequence] int,
        Caption nvarchar(50), 
        URL nvarchar(1024), 
        SitePageID int,
        DefaultSiteImageID int,
        HoverSiteImageID int,
        ActiveSiteImageID int,
        PageTabID int,
        Target nvarchar(255),
        AddQS nvarchar(25),
        DocumentID int
    ) 


EXEC sp_xml_removedocument @idoc