Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
I am trying to update a field in a sql server table. There are times when I may get multiple records returned in which case they will all need to be updated. I am getting this error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
What I don't understand is that the second query listed works fine when multiple records are returned and I don't see any difference in the two.
1. UPDATE table1 SET CHANGEDPOLICY = 'Y' WHERE RTRIM(claim) LIKE 'xxxxx xxx%'
2. UPDATE table2 SET special49 = 'Y' WHERE RTRIM(OCCURNUM) like 'xxxxx%'
number 1 affects 2 rows and number two affects 3 rows. As I said #2 works fine. Please help as everybody in my office has looked at this and we are all stumped.

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |