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 |
|
sqlslick
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-01 : 16:34:04
|
Hi Guys,
I need to do something simple. Consider the following 2 records:
ITEM_NO|VENDOR|UM|SEQ
1|A|BX|1
1|A| |2
I need to set the UM field for all records that have SEQ = 2 the same as where SEQ = 1. Therefore, in this particular example UM will = BX for the second record. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-01 : 17:39:07
|
Are there more conditions?
Same ITEM_NO or something else?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sqlslick
Yak Posting Veteran
83 Posts |
Posted - 2009-09-02 : 13:42:47
|
Hey webfred,
It is actually the same ITEM_NO. Let me expand on the example with a few more records for clarity:
ITEM_NO|VENDOR|UM|SEQ
1|A|BX|1
1|A| |2
2|D|CT|1
2|D| |2
3|B|KG|1
3|B| |2
4|C|DR|1
4|C| |2
Thanks in advanced for your help! |
|
|
|
|
|
|
Update Field in Same Table