EA7_spBulkUpdateUserFieldPrivacy

        CREATE  PROCEDURE dbo.EA7_spBulkUpdateUserFieldPrivacy
            (
                @BackOfficeID int,
                @XML ntext
            )

        AS
            DECLARE @idoc int

            EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

            DELETE 
                FROM EA7_UserFieldPrivacy
                WHERE EA7_UserFieldPrivacy.BackOfficeID=@BackOfficeID 
                and Fieldid in (
                    select ID FROM OPENXML (@idoc, '/UserEEFieldPrivacy/FieldIds/Item',1) WITH(ID int, PrivacyOn bit))

            INSERT INTO EA7_UserFieldPrivacy(
                    BackOfficeID,
                    FieldID,
                    FieldTypeID,
                    FieldAttribId
                ) SELECT
                @BackOfficeID, ID, TypeID, AttribID
                FROM OPENXML (@idoc, '/UserEEFieldPrivacy/FieldIds/Item',1) WITH(ID int, TypeID int, AttribID int, PrivacyOn bit) where PrivacyOn = 1

            EXEC sp_xml_removedocument @idoc