spBulkUpdate_UserRoleMembership

Parameters

Parameter	Parameter Type	Mode	Description
@ClientUsersID	int	IN
@XML	ntext	IN

Definition

Copy


CREATE   PROCEDURE [dbo].[spBulkUpdate_UserRoleMembership]
(
    @ClientUsersID int,
    @XML ntext
)

AS

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

DELETE UserRoles
FROM UserRoles
WHERE ClientUsersID=@ClientUsersID
AND ManuallyAdded=1

INSERT INTO UserRoles(
        ClientUsersID,
        ManuallyAdded,
        ClientRolesID        
    ) SELECT
    @ClientUsersID,
    1,
    ID FROM OPENXML (@idoc, '/RoleMemberships/ClientRolesIDs/Item',1) WITH(ID int) 

EXEC sp_xml_removedocument @idoc