spUpdateQueryBasedUserRoles

            CREATE PROCEDURE [dbo].[spUpdateQueryBasedUserRoles]
            (
                @UserID    int,
                @XML as ntext,
                @DeleteSQL ntext
            )

            AS

            DECLARE @idoc int

            EXEC sp_xml_preparedocument @idoc OUTPUT, @XML

            EXEC sp_executesql @DeleteSQL

            INSERT INTO UserRoles (ClientUsersID,ClientRolesID, ManuallyAdded) SELECT @UserID,A.ID, 0 FROM 
            OPENXML (@idoc, '/ArrayOfIDItem/IDItem', 1) with (ID int) A WHERE A.ID>0

            Update ClientUsers SET MembershipRefreshedOn=getutcdate() where ID=@UserID

            EXEC sp_xml_removedocument @idoc