spBulkUpdate_ClientUserFieldPrivacy

            CREATE      PROCEDURE [dbo].[spBulkUpdate_ClientUserFieldPrivacy]
                (
                    @RaisersEdgeRecordID int,
                    @XML ntext
                )

                AS
            BEGIN
                set nocount on

                DECLARE @idoc int
                DECLARE @BackOfficeSystemPeopleID int
                exec dbo.spGetBackOfficeSystemPeopleID @RaisersEdgeRecordID, 0, @BackOfficeSystemPeopleID OUTPUT

                EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

                UPDATE ClientUserFieldPrivacy
                SET Private = b.PrivacyOn
                FROM ClientUserFieldPrivacy FP
                INNER JOIN OPENXML (@idoc, '/UserFieldPrivacy/FieldIds/Item',1) WITH(ID int, AttribID int, PrivacyOn bit) b
                ON FP.FieldID = b.ID
                AND FP.FieldAttribID = b.AttribID
                AND FP.BackOfficeSystemPeopleID = @BackOfficeSystemPeopleID

                EXEC sp_xml_removedocument @idoc
            END