Assuming the following Rights table, how do you select out the right, change the RoleKey to some value, and then reinsert those rows back into this table?

RightKey    RoleKey     UserKey     RightName                                          RightCode                                          AllowDeny
----------- ----------- ----------- -------------------------------------------------- -------------------------------------------------- -----------
27          NULL        NULL        Add User                                           sys_add_user                                       1
28          NULL        NULL        Edit User                                          sys_edit_user                                      1
29          NULL        NULL        Remove User                                        sys_remove_user                                    1
30          NULL        NULL        Lock User                                          sys_lock_user                                      1

Thanks

Kevin