spBulkUpdate_RoleTaskPrivs

CREATE     PROCEDURE dbo.spBulkUpdate_RoleTaskPrivs
(
    @XML as ntext
)

AS

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

declare @RoleID int

    SELECT TOP 1 @RoleID=ClientRoleID FROM OPENXML (@idoc, '/TaskSecurityItems',1) WITH (ClientRoleID int)

    delete FROM RoleObjectPrivs WHERE ClientRolesID = @RoleID AND ObjectTypesID=5

        insert into RoleObjectPrivs(
            ObjectTypesID,
            ClientRolesID,
            ObjectGuid,
            CanEdit
        ) SELECT 
            5,
            @RoleID,
            ObjectGuid,
            HasAccess
         FROM OPENXML (@idoc, '/TaskSecurityItems/TasksSettings/Item',1) WITH (ObjectGuid uniqueidentifier, HasAccess bit)

EXEC sp_xml_removedocument @idoc