spBulkUpdate_SiteCultures

create PROCEDURE [dbo].[spBulkUpdate_SiteCultures]
        (
        @ClientSitesId int,
        @XML ntext
        )

        AS

        DECLARE @idoc int

        EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

        begin transaction

        DELETE 
        FROM SiteCultures
        WHERE ClientSitesId=@ClientSitesId

        INSERT INTO SiteCultures(
            ClientSitesId,
            [Name],
            [Description]
        ) SELECT
        @ClientSitesId, [Name], [Description]
        FROM OPENXML (@idoc, '/ArrayOfResultRow/ResultRow',3) 
            WITH(
                [Name] nvarchar(10),
                [Description] nvarchar(100)
            ) 

        EXEC sp_xml_removedocument @idoc

        commit transaction