-
No luck. I just ran it again and zero rows were updated.
-
Oops...gave you the wrong query. Here's the correct one, which is still not updating any rows:
update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where x.imaitm = u.legacy_item)
where exists (
select 1 from f4101 x
where x.imaitm = u.legacy_item);
Steve
-
Hi I am not able to figure out the reason but if ur columns are VARCHAR type, sometime the value may not match. try using TRIM() option.
update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item))
where exists (
select 1 from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item));
Cheers!
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|