Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Miko
Starting Member
2 Posts |
 Posted - 2008-04-25 : 05:07:02
|
| Hello, all.I am new to SQL querying and I came across an issue while experimenting.Say, I have two tables like the following, a Users table at the top, and a Roles table at the bottom (drawing the issue as I'm not fluent in English to explain):(Users table)UserId | RoleId | RoleOldId-------+--------+----------1......|x.......|11........2......|y.......|22........3......|z.......|22........(Roles table)RoleId | RoleOldId | RoleName-------+-----------+-------------10.....|11.........|Anonymous....20.....|22.........|Superuser....30.....|33.........|AdministratorThe Roles table was changed to include a new column Roles.RoleId and the old column is named Roles.RoleOldId. Same is done for Users table. Assume these are not foreign and/or primary keys. How can I fill Users.RoleId with new Roles.RoleIds, matching RoleOldIds at each tables? The resulting (x, y, z) set of Users table will be (10, 20, 20).Thank you for your time. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-25 : 06:14:07
|
| update Uset RoleId = R.RoleIdfrom Users U join Roles R on U.RoleOldId = R.RoleOldId_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Miko
Starting Member
2 Posts |
Posted - 2008-04-25 : 06:44:19
|
quote:
Originally posted by spirit1
oh and read this to grasp how to modify data in any way in a query made up of joins:http://weblogs.sqlteam.com/mladenp/archive/2007/08/19/60292.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com
Thank you, spirit1.This is a weekend's read. But it looks like I need to read more on relational algebra.Thanks again. |
|
|
|
|
|
|
Populating a column with new matching values...