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 |
|
scott_leseman
Starting Member
5 Posts |
 Posted - 2009-10-14 : 16:18:02
|
| I have been running an update query for several months now and have found a problem. The query updates 2 fields to hard coded values. In some cases only one of the fields has been updating. I cannot thing of anything to explain this.Before the query runs MIN_PAID10 can have a value of N or YBefore the query runs ADJ will be nullUPDATE tableSET MIN_PAID10 = 'N',ADJ = 'Y'FROM table...After the query runs I am finding cases where ADJ = Y and MIN_PAID10 = Y. That is not possible with this query. I can find cases where it has updated both correctly and incorrectly within the data. This is running against an SQL2K box. The table name and where filters are irrelevant because they are working because I have data with ADJ set to Y. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-14 : 16:53:52
|
hm...the table name and where filters are irrelevant because they are working...Then good luck 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Update query problem