Cacher is the code snippet organizer for pro developers

DELETE ur FROM security.UserRole ur
                            JOIN security.[User] u ON ur.UserId = u.UserId
                            JOIN security.[Role] r ON ur.RoleId = r.RoleId
                            WHERE u.SrcUserId = @UserId AND r.SrcRoleId = @RoleId