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 |
|
korinab
Starting Member
1 Post |
 Posted - 2005-07-06 : 15:45:33
|
| I'm doing a update on a table in SQL Server. The fields I am updating are skill_major_1 through skill_major_20 each of these skill major's has a skill_sub_1_1 through skill_sub_1_5, the first number changes for each major.What I'm trying to do is search for a possible value like skill_major_1='OFFICE' AND skill_sub_1_#='PARLEG' null out the PARLEG and move it to another major like Legal (if LEGAL is one of the majors already in the record to a sub with null in it or if not move the major and sub to ones with NULL in them) like skill_major_2='LEGAL' and skill_sub_2_1='PARA'.I can explain further if needed and any help would be greatly appreciated. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
|
|
|
|
|
Updating a table