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 |
|
srujanavinnakota
Starting Member
34 Posts |
 Posted - 2010-07-02 : 13:07:50
|
| Hi, Can anyone help me with the logic. I have a scenario where I need to check for the value 50 in OldVal and NewVal columns for each ID. No Matter where it is, but if OldVAl Or NewVal is 50 then it need to pick up the ID.ID OldVal NewVal1 100 101 10 501 50 1501 150 1002 10 13 300 303 30 504 50 1004 100 50 4 50 1505 300 305 30 10Thanks In Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Help with Row Comparison