USP_BULKUPDATE_CMSSITEURLS

CREATE PROCEDURE [dbo].[USP_BULKUPDATE_CMSSITEURLS]
        (
        @ClientSitesId int,
        @XML ntext
        )

        AS

        DECLARE @idoc int

        EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

        begin transaction

        DELETE 
        FROM CMSSiteURLS
        WHERE ClientSitesId=@ClientSitesId

        INSERT INTO CMSSiteURLS(
                  [ID],
            ClientSitesId,
            [URL],
            [SEQUENCE]
        ) SELECT
        newid(), @ClientSitesId, [URL], [SEQUENCE]
        FROM OPENXML (@idoc, '/ArrayOfResultRow/ResultRow',3) 
            WITH(
                [URL] nvarchar(255),
                [SEQUENCE] int        
            ) 

        EXEC sp_xml_removedocument @idoc

        commit transaction